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
|
# name: test/sql/show_select/test_describe_all.test
# description: Test describe all
# group: [show_select]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE integers(i INTEGER, j INTEGER, a INTEGER);
statement ok
DESCRIBE;
query TTTTTT
DESCRIBE
----
memory main integers [i, j, a] [INTEGER, INTEGER, INTEGER] false
# Issue 6393
statement ok
DROP TABLE integers
statement ok
CREATE TABLE t(plant TEXT, dt DATE, mwh BIGINT);
query TTTTTT
DESCRIBE;
----
memory main t [plant, dt, mwh] [VARCHAR, DATE, BIGINT] false
|