1
Obtaining Information on the Contents of the Database
2
=====================================================
4
Drizzle provides two schema per catalog that contain data about the contents
5
of the schema, the state of the database instance, and other additional
6
information that might be useful to a user. In addition Drizzle supports
7
"SHOW" commands, and DESCRIBE, which can be used by a user to gain
8
additional information.
10
The INFORMATION_SCHEMA only contains data that is the SQL standard requires.
11
More information can be gained by the tables found in the DATA_DICTIONARY
1
Obtaining Information on the Database Contents
2
==============================================
4
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.
6
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.