在线等 ，特急！！要获得table1中所有栏位的名称，我怎么写？

[st_2000]

如题

[sdhdy]

select * from tablename

[sdhdy]

select name from syscolumns where id=object_id('table1')

[sdhdy]

楼主说的应该是二者之一吧！

[pengdali]

select * from sysobjects where xtype='U' and status>0

[cp07]

select name from syscolumns where id=object_id('table1')
是对的