我一般用这个视图 Create view fielddesc as select o.name as oname, c.name as cname,convert(varchar(30),p.value) as value,p.smallid as psmallid,t.name as tname from syscolumns c join systypes t on c.xtype = t.xtype join sysobjects o on o.id=c.id left join sysproperties p on p.smallid=c.colid and p.id=o.id where o.xtype='U' 查询时: Select * from fielddesc where oname = '你的表名'
select name from 数据库名..syscolumns where id=object_id('数据库名..表名')
select name from syscolumns where id = object_id('表名称') order by colid
select * from syscolumns where id=object_id(N'[tablename]')
Create view fielddesc
as
select o.name as oname, c.name as cname,convert(varchar(30),p.value) as value,p.smallid as psmallid,t.name as tname
from syscolumns c
join systypes t on c.xtype = t.xtype
join sysobjects o on o.id=c.id
left join sysproperties p on p.smallid=c.colid and p.id=o.id
where o.xtype='U' 查询时:
Select * from fielddesc where oname = '你的表名'