Hour 21. Working with the System Catalog
What You’ll Learn in This Hour:
• 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
In 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. This hour ...
Get Sams Teach Yourself SQL in 24 Hours, Fifth 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.
