12 lines
413 B
Text
12 lines
413 B
Text
statement ok
|
|
CREATE TABLE myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));
|
|
|
|
query TTTT
|
|
SELECT * FROM kanto.information_schema.tables WHERE table_schema<>'information_schema';
|
|
----
|
|
kanto myschema mytable BASE TABLE
|
|
|
|
query TT
|
|
SELECT column_name, data_type FROM kanto.information_schema.columns WHERE table_catalog='kanto' AND table_schema='myschema' AND table_name='mytable';
|
|
----
|
|
mycolumn Int64
|