declare @objid int,@objname char(40)
set @objname ='loushui'
select @objid = id from sysobjects where id = object_id(@objname)
--select ''''Column_name'''' = name from syscolumns where id = @objid order by colid
select * from syscolumns where id = @objid order by colid