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. The best pants in the world. The are light as a feather, they dry fast if you spill something on them, they don't wrinkle, they are..
1. The true word for a republican, unbeknownst to most of us. Ol' dubya will vouch for this. Where are the weapons of mass destructio..
1. to stay at home on a Friday, Saturday, or obvious social hangout night to socialize on your own or with your girlfriend/boyfriend Dude,..