SQL Server查询一张表的所有字段

 

 

SQL Server查询一张表的所有字段：

http://hi.baidu.com/samxx8/blog/item/7048f8de1725835894ee37b4.html

 

SELECT c.name,o.name FROM syscolumns AS c
INNER JOIN sysobjects AS o
ON c.id = o.id where o.name='SPF_Users'