Summary
The data dictionary is a DBA's best friend. You do not have to memorize the data dictionary; however, you must be very familiar with it because it is used frequently. Although the details of the data dictionary vary from one implementation to another, the content remains conceptually the same in all relational databases. You must follow the syntax and rules of your database management system, but today's examples should give you the confidence to query your data dictionary and to be creative when doing so.
Tip
You can save queries that you might use on a regular basis. This saves you the time it would take to rewrite the queries.
Note
Exploring the data dictionary is an adventure, and you will need to explore in order to learn to use ...
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
