根据表名 查询 表的列，备注，类型等 SQL

-- 根据表名 查询 表的列，备注，类型等。
SELECT
Column_Name AS columnName,
COLUMN_COMMENT AS columnComment,
upper(data_type) AS colType
FROM
information_schema. COLUMNS
WHERE
table_name ='Z_ACCOUNT_gtbss'
AND Column_Name NOT IN (
'RESULT_ID',
'AUDIT_RESULT_MASTER',
'ROW_ID_LOCAL_BFAS'
)
ORDER BY
ORDINAL_POSITION ASC