select d.name,a.name,case when COLUMNPROPERTY( object_id(d.name),a.name,'IsIdentity')=1 then '是标识' else '' end 是否是标识,b.name ,a.length, a.isnullable from syscolumns a, systypes b,sysobjects d where a.xtype=b.xusertype and a.id=d.id and d.xtype='U'
调试欢乐多
select a.name 表名,b.name 字段 from syscolumns b, sysobjects a
where b.id=a.id and b.status=0x80 and a.name='aaa'
--aaa为表名