摘要:
SELECT 表名 = case when a.colorder=1 then d.name else '' end, 表说明 = case when a.colorder=1 then isnull(f.value,'') else '' end, 字段序号 = a.colorder, 字段名 = 阅读全文
摘要:
SHOW FULL COLUMNS FROM test_emp; DESCRIBE test_emp; SELECT c.COLUMN_NAME,c.COLUMN_TYPE,c.COLUMN_COMMENT,c.IS_NULLABLE,c.COLUMN_DEFAULT,c.COLUMN_KEYFRO 阅读全文