查询一个表的所有字段
select COLUMN_NAME from information_schema.COLUMNS where table_name = '要查询表的名字';
SQL 能否怎么查出某个表的所有字段并保留原来的顺序?
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG=N'DB_NAME' AND TABLE_SCHEMA=N'dbo' AND TABLE_NAME=N'TABLE_NAME' ORDER BY ORDINAL_POSITION