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 table_name = ''''你的表名''''
还有个更强的语句，是邹建写的，也写出来吧
SELECT
(case when a.colorder=1 then d.name else '''''''' end) N''''表名'''',
a.colorder N''''字段序号'''',
a.name N''''字段名'''',
(case when COLUMNPROPERTY( a.id,a.name,''''IsIdentity'''')=1 then ''''√''''else '''''''' end) N''''标识'''',
(case when (SELECT count(*)
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
上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
