Data Dictionary

What is Data Dictionary?


1.

A data dictionary is (generally) a read-only set of tables and views that holds metadata - used in a database management system. The data dictionary may be considered a database in its own right.

Amongst other things, a Data Dictionary holds the following information:

* Usernames, Roles and Privileges

*Schema Objects

*IntegrityConstraints

*Stored procedures and Triggers

*General Database Structure

*Audit information

*Space allocations

One benefit of a well prepared data dictionary is a consistency between data items across different tables.

several tables may hold telephone numbers, using a data dictionary the format of this telephone number field will be consistent.


17

Random Words:

1. A normal Italian Stallion by day, who transforms into a vampire at the stroke of midnight. May suck up to 7 pints of blood in one night...
1. A gift for a new mother, typically an expensive piece of jewellery. "Pushing" refers to labour of childbirth. So what did sh..
1. Spectrum computer game (also converted to other platforms), the official follow-up to Manic Miner. A platform arcade-style game, it fea..