mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-07 05:42:57 +00:00
42 lines
770 B
Plaintext
42 lines
770 B
Plaintext
create table t1 (a timestamp time index);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t2 (b timestamp time index);
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t1;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t2;
|
|
|
|
Affected Rows: 0
|
|
|
|
-- SQLNESS ARG restart=true
|
|
show tables;
|
|
|
|
+---------+
|
|
| Tables |
|
|
+---------+
|
|
| numbers |
|
|
+---------+
|
|
|
|
create table t3 (c timestamp time index);
|
|
|
|
Affected Rows: 0
|
|
|
|
desc table t3;
|
|
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
| Column | Type | Key | Null | Default | Semantic Type |
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
| c | TimestampMillisecond | PRI | NO | | TIMESTAMP |
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
|
|
drop table t3;
|
|
|
|
Affected Rows: 0
|
|
|