o.id=c.id leftjoin sysproperties p on p.smallid=c.colid and p.id=o.id where o.xtype=''''U''''
查询时:
Select*from fielddesc where table_name =''''你的表名''''
还有个更强的语句,是邹建写的,也写出来吧
SELECT (casewhen a.colorder=1then d.name else''''''''end) N''''表名'''', a.colorder N''''字段序号'''', a.name N''''字段名'''', (casewhenCOLUMNPROPERTY( a.id,a.name,''''IsIdentity'''')=1then''''√''''else''''''''end) N''''标识'''', (casewhen (SELECTcount(*) FROM sysobjects WHERE (name in (SELECT name FROM sysindexes WHERE (id = a.id) AND (indid in (SELECT indid FROM sysindexkeys WHERE (id = a.id) AND (colid in