[SQL]查询表里的字段名

Select Name from syscolumns Where ID=OBJECT_ID('表名')
select * from information_schema.tables WHERE TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW'
select * from information_schema.views
select * from information_schema.columns