select table_name,column_name,ordinal_position from INFORMATION_SCHEMA.COLUMNS
where table_name='m_goods_code' --如果单查一个表在此处填入表名
order by table_name,ordinal_position
SELECT
TABLE_NAME = convert(sysname,o.name),
COLUMN_NAME = convert(sysname,c.name),
ORDINAL_POSITION = convert(int,
(
select count(*)
from syscolumns sc
where sc.id = c.id
AND sc.number = c.number
AND sc.colid <= c.colid
))
FROM
sysobjects o,
syscolumns c
LEFT OUTER JOIN syscomments m on c.cdefault = m.id
AND m.colid = 1
WHERE c.id = o.id AND (o.type not in ('P', 'FN', 'TF', 'IF') OR (o.type in ('TF', 'IF') and c.number = 0))
--and o.name='m_goods_code' 如果单查一个表在此处填入表名
ORDER BY table_name,ORDINAL_POSITION