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.
0

Random Words:

Quode
1. a chode that farts. (see chode) johny has a tiny little quode See quode, chode, fart, gas 1. a chode that farts. (see chode) johny ..
Read more
Afea
1. feo(a) = ugly afea = makes ugly Spanish 'non-verb' used to specify something making ugly another thing. El shoutbox no se a..
Read more
Loose Willis
1. What Bruce Willis would be if he wasn't so tight. "I went THE WHOLE NINE YARDS with the girl, but she was Loose Willis."..
Read more
Book Banner