1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
SELECT CREATE_CATALOG("foo");
CREATE_CATALOG("foo")
1
SELECT DROP_CATALOG("foo");
DROP_CATALOG("foo")
1
SELECT CREATE_CATALOG("foo1");
CREATE_CATALOG("foo1")
1
SELECT CREATE_CATALOG("foo2");
CREATE_CATALOG("foo2")
1
SELECT CREATE_CATALOG("foo3");
CREATE_CATALOG("foo3")
1
SELECT CREATE_CATALOG("foo4");
CREATE_CATALOG("foo4")
1
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS;
CATALOG_NAME
foo3
foo1
foo2
foo4
local
SELECT DROP_CATALOG("foo1");
DROP_CATALOG("foo1")
1
SELECT DROP_CATALOG("foo2");
DROP_CATALOG("foo2")
1
SELECT DROP_CATALOG("foo3");
DROP_CATALOG("foo3")
1
SELECT DROP_CATALOG("foo4");
DROP_CATALOG("foo4")
1
|