23.1. The INFORMATION_SCHEMA SCHEMATA
Table
A schema is a database, so the SCHEMATA
table
provides information about databases.
The following statements are equivalent:
SELECT SCHEMA_NAME AS `Database`
FROM INFORMATION_SCHEMA.SCHEMATA
[WHERE SCHEMA_NAME LIKE 'wild
']
SHOW DATABASES
[LIKE 'wild
']