| TABLE 1: Views Containing Meta Data for All Database Objects |
| View |
Description |
| CHECK_CONSTRAINTS |
Contains one row for each CHECK constraint owned by the current user in the current database. |
| COLUMN_DOMAIN_USAGE |
Contains one row for each column owned by the current user in the current database that has a user-defined data type. |
| COLUMN_PRIVILEGES |
Contains one row for each column with a privilege granted either to or by the current user in the current database. |
| COLUMNS |
Contains one row for each column accessible to the current user in the current database. |
| CONSTRAINT_COLUMN_USAGE |
Contains one row for each column owned by the current user in the current database that has a constraint defined on it. |
| CONSTRAINT_TABLE_USAGE |
Contains one row for each table owned by the current user in the current database that has a constraint defined on it. |
| DOMAIN_CONSTRAINTS |
Contains one row for each user-defined data type accessible to the current user in the current database with a rule bound to it. |
| DOMAINS |
Contains one row for each user-defined data type accessible to the current user in the current database. |
| KEY_COLUMN_USAGE |
Contains one row for each column owned by the current user in the current database that is constrained as a key. |
| REFERENTIAL_CONSTRAINTS |
Contains one row for each foreign constraint owned by the current user in the current database. |
| SCHEMATA |
Contains one row for each database that has permissions for the current user. |
| TABLE_CONSTRAINTS |
Contains one row for each table constraint owned by the current user in the current database. |
| TABLE_PRIVILEGES |
Contains one row for each table privilege granted to or by the current user in the current database. |
| TABLES |
Contains one row for each table in the current database for which the current user has permissions. |
| VIEW_COLUMN_USAGE |
Contains one row for each column owned by the current user in the current database and used in a view definition. |
| VIEW_TABLE_USAGE |
Contains one row for each table owned by the current user in the current database that is used in a view. |
| VIEWS |
Contains one row for views accessible to the current user in the current database. |