Files
Ruihang Xia 85a231850d fix: add tailing separator to prefix (#4078)
* fix: add tailing separator to prefix

Signed-off-by: Ruihang Xia <waynestxia@gmail.com>

* project select result

Signed-off-by: Ruihang Xia <waynestxia@gmail.com>

---------

Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
2024-05-30 15:29:26 +00:00

20 lines
323 B
SQL

create schema abc;
use abc;
create table t (ts timestamp time index);
create schema abcde;
use abcde;
create table t (ts timestamp time index);
select table_catalog, table_schema, table_name from information_schema.tables where table_schema != 'information_schema';
use public;
drop schema abc;
drop schema abcde;