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.