Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.4 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA General Tables  /  The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table

28.3.38 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table

TheSCHEMATA_EXTENSIONS table augments theSCHEMATA table with information about schema options.

TheSCHEMATA_EXTENSIONS table has these columns:

  • CATALOG_NAME

    The name of the catalog to which the schema belongs. This value is alwaysdef.

  • SCHEMA_NAME

    The name of the schema.

  • OPTIONS

    The options for the schema. If the schema is read only, the value containsREAD ONLY=1. If the schema is not read only, noREAD ONLY option appears.

Example

mysql> ALTER SCHEMA mydb READ ONLY = 1;mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA_EXTENSIONS       WHERE SCHEMA_NAME = 'mydb';+--------------+-------------+-------------+| CATALOG_NAME | SCHEMA_NAME | OPTIONS     |+--------------+-------------+-------------+| def          | mydb        | READ ONLY=1 |+--------------+-------------+-------------+mysql> ALTER SCHEMA mydb READ ONLY = 0;mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA_EXTENSIONS       WHERE SCHEMA_NAME = 'mydb';+--------------+-------------+---------+| CATALOG_NAME | SCHEMA_NAME | OPTIONS |+--------------+-------------+---------+| def          | mydb        |         |+--------------+-------------+---------+

Notes