1
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local";
3
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local";
5
SELECT CREATE_CATALOG("foo");
8
SELECT DROP_CATALOG("foo");
11
SELECT drop_catalog("local");
12
ERROR HY000: You can not drop the 'local' catalog.
13
SELECT drop_catalog("does_not_exist");
14
ERROR HY000: Catalog 'does_not_exist' does not exist.
15
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local";
17
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local";