获取sql server2008表字段信息

SELECT T.name as tablename,C.* from sys.columns C,sys.tables T where C.object_id=T.object_id and T.name='表名'