方法1:
declare @objid int,@objname char(40)
set @objname = 'tablename'
select @objid = id from sysobjects where id = object_id(@objname)
select 'Column_name' = name from syscolumns where id = @objid order by colid
方法2:
select Name from syscolumns where id=object_id( 'DataBaseName.TableName')