"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/getting_information.rst" (6 May 2012, 633 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:

As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

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 show describe