RT
谢谢!!!

我刚才搜索了一下..以前发过..
但是讲得不详细...

没人回答!!!
不过我找到了个例子!!!
拿出来与大家分享.
declare @objid int
declare @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