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']