O'Reilly logo

Sams Teach Yourself SQL in 24 Hours, Fifth Edition by Arie D. Jones, Ron D. Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required