Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 21. Working with the System Catalog
The system catalog is created either automatically with the creation of the database, or by the database administrator immediately following the creation of the database. For example, a set of predefined, vendor-provided SQL scripts in Oracle is executed, which builds all the database tables and views in the system catalog that are accessible to a database user. The system catalog tables and views are system-owned and not specific to any one schema. In Oracle, for example, the system catalog owner is a user account called SYS, which has full authority in the database. In Sybase, the system catalog for the SQL server is located in the MASTER database.
