Complete the following sentence. The infofmation_schema. schemata table contains information about
A.
the table structure for all databases.
B.
all of the tables, triggers and views for every database.
C.
all of the databases on the server, such as name, character set and collation.
D.
every database’s structure including tables, triggers, stored routines, views, etc.
Explanation:
mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; — shows list of databases under SCHEMA_NAME Heading (12 in my case)
— +————–+——————–+—————————-+————————+———-+
— | CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
— +————–+——————–+—————————-+————————+———-+