1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
SELECT CREATE_CATALOG("foo");
SELECT DROP_CATALOG("foo");
SELECT CREATE_CATALOG("foo1");
SELECT CREATE_CATALOG("foo2");
SELECT CREATE_CATALOG("foo3");
SELECT CREATE_CATALOG("foo4");
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS ORDER BY CATALOG_NAME;
SELECT DROP_CATALOG("foo1");
SELECT DROP_CATALOG("foo2");
SELECT DROP_CATALOG("foo3");
SELECT DROP_CATALOG("foo4");
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
|