金仓数据库kingbaseESV8实现查询某个数据表所有字段并且将数据由列转为一行，用逗号分隔

SELECT WM_CONCAT(COLUMN_NAME) FROM USER_TAB_COLUMNS WHERE TABLE_NAME=""

随oracle改动

SELECT WM_CONCAT(COLUMN_NAME)  FROM all_tab_cols WHERE table_name = ''

–查询某张表中的字段名，字段类型，是否为空，字段长度等信息
SELECT COLUMN_ID, TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = ‘EMPLOYEES’
ORDER BY COLUMN_ID;

–查询某张表中的字段名，字段类型，是否为空，字段长度等信息
SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = ‘EMPLOYEES’