GBase 库中查询表的列信息


select 
ORDINAL_POSITION,rtrim(COLUMN_NAME),rtrim(DATA_TYPE) from
information_schema.COLUMNS whereTABLE_SCHEMA=upper('asiainfo')andTABLE_NAME=upper('kpi_leader_all_36')orderbyORDINAL_POSITION

版权声明：本文为lbfk原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。