Hour 21. Working with the System Catalog

Team-Fly    

 
Sams Teach Yourself SQL in 24 Hours, Third Edition
By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Part VII.  Summarized Data Structures


Hour 21. Working with the System Catalog

During this hour, you learn about the system catalog, commonly referred to as the data dictionary in some relational database implementations . By the end of this hour, you will understand the purpose and contents of the system catalog and will be able to query it to find information about the database based on commands that you have learned in previous hours. Each major implementation has some form of a system catalog that stores information about the database itself. This hour shows examples of the elements contained in a few different system catalogs.

The highlights of this hour include

  • What the system catalog is

  • How the system catalog is created

  • What data is contained in the system catalog

  • Examples of system catalog tables

  • Querying the system catalog

  • Updating the system catalog


Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net