declare @objid int,@objname char(10)
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
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