Progress
SQL-92
Guide and Reference
Overview of System Catalog Tables
Progress SQL-92 maintains a set of system tables for storing information about tables, columns, indexes, constraints, and privileges.
All users have read access to the system catalog tables. SQL Data Definition Language (DDL) statements and GRANT and REVOKE statements modify system catalog tables. The system tables are modified in response to these statements, as the database evolves and changes.
The owner of the system tables is sysprogress. If you connect to a Progress SQL-92 environment with a username other than sysprogress, you must use the owner qualifier when you reference a system table in a SQL query. Alternatively, you can issue a SET SCHEMA ’sysprogress’ statement to set the default username for unqualified table names to ’sysprogress’.
Core tables store information on the tables, columns, and indexes that make up the database. The remaining tables contain detailed information on database objects, and statistical information.
Table B–1 lists the system catalog tables in the same order that they are presented in following sections.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |