获取 SQL 列名

SELECT name
FROM syscolumns
WHERE (id =
(SELECT id
FROM sysobjects
WHERE (id = OBJECT_ID('userinfo'))))
ORDER BY colid

 

userinfo是表名