1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
CATALOG_NAME
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
CATALOG_NAME
SELECT CREATE_CATALOG("foo");
CREATE_CATALOG("foo")
1
SELECT DROP_CATALOG("foo");
DROP_CATALOG("foo")
1
SELECT drop_catalog("local");
ERROR HY000: You cannot drop the 'local' catalog.
SELECT drop_catalog("does_not_exist");
ERROR HY000: Catalog 'does_not_exist' does not exist.
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
CATALOG_NAME
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
CATALOG_NAME
|