Sql Server 2008中获取表的字段信息

sqlserver2008

获取所有字段：

select column_name from information_schema.columns where table_name='表名'

获取表中字段个数：

select count(name) from syscolumns where id=object_id('表名')