gbase笔记

查看表结构

select TABLE_SCHEMA, TABLE_NAME, TABLE_COMMENT
from information_schema.tables 
where TABLE_SCHEMA = 'aaa' 
and TABLE_NAME in ('a','b') 
order by TABLE_NAME;

select TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, COLUMN_COMMENT
from  information_schema.COLUMNS 
where TABLE_SCHEMA = 'aaa' 
and TABLE_NAME in ('a','b') 
order by TABLE_NAME;