MySQL 5.0 Reference Manual :: 19 INFORMATION_SCHEMA Tables :: 19.1 The INFORMATION_SCHEMA SCHEMATA Table
Section Navigation [Toggle]
- 19 INFORMATION_SCHEMA Tables
- 19.1 The INFORMATION_SCHEMA SCHEMATA Table
- 19.2 The INFORMATION_SCHEMA TABLES Table
- 19.3 The INFORMATION_SCHEMA COLUMNS Table
- 19.4 The INFORMATION_SCHEMA STATISTICS Table
- 19.5 The INFORMATION_SCHEMA USER_PRIVILEGES Table
- 19.6 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- 19.7 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- 19.8 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- 19.9 The INFORMATION_SCHEMA CHARACTER_SETS Table
- 19.10 The INFORMATION_SCHEMA COLLATIONS Table
- 19.11 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- 19.12 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- 19.13 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- 19.14 The INFORMATION_SCHEMA ROUTINES Table
- 19.15 The INFORMATION_SCHEMA VIEWS Table
- 19.16 The INFORMATION_SCHEMA TRIGGERS Table
- 19.17 The INFORMATION_SCHEMA PROFILING Table
- 19.18 Other INFORMATION_SCHEMA Tables
- 19.19 Extensions to SHOW Statements
A schema is a database, so the
SCHEMATA table provides information
about databases.
INFORMATION_SCHEMA
Name |
SHOW
Name |
Remarks |
CATALOG_NAME |
NULL |
|
SCHEMA_NAME |
Database | |
DEFAULT_CHARACTER_SET_NAME |
||
DEFAULT_COLLATION_NAME |
||
SQL_PATH |
NULL |
Notes:
DEFAULT_COLLATION_NAMEwas added in MySQL 5.0.6.
The following statements are equivalent:
SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE 'wild']
User Comments
Add your own comment.