KSQL查看表结构等

显示所有表

SHOW TABLES

显示表定义

SHOW COLUMNS FROM CT_LAD_TEST3

显示所有视图

SELECT KSQL_TABNAME FROM KSQL_USERTABLES where type = 'V'

SELECT count(*) FROM KSQL_USERTABLES where type = 'V';
SELECT count(*) FROM KSQL_USERTABLES where type <> 'V';
SELECT count(*) FROM KSQL_USERTABLES;