Obtaining Information on the Database ContentsΒΆ
Drizzle provides two schema per catalog that provide information about the contents of the database, the state of the database instance, and additional user-centric information. In addition, Drizzle supports SHOW and DESCRIBE commands, which can be used to obtain additional information.
The INFORMATION_SCHEMA only contains data that the SQL standard requires. More information can be gained by the tables found in the DATA_DICTIONARY schema.
- DATA_DICTIONARY
- INFORMATION_SCHEMA
- CHECK_CONSTRAINTS
- COLUMNS
- COLUMN_DOMAIN_USAGE
- COLUMN_PRIVILEGES
- CONSTRAINT_COLUMN_USAGE
- CONSTRAINT_TABLE_USAGE
- DOMAINS
- DOMAIN_CONSTRAINTS
- KEY_COLUMN_USAGE
- PARAMETERS
- REFERENTIAL_CONSTRAINTS
- ROUTINES
- ROUTINE_COLUMNS
- SCHEMATA
- TABLES
- TABLE_CONSTRAINTS
- TABLE_PRIVILEGES
- VIEWS
- VIEW_COLUMN_USAGE
- VIEW_TABLE_USAGE
- SHOW
- DESCRIBE
