å¦ä½ä½¿ç¨SQLèæ¬æ¥çæ°æ®åºä¸è¡¨çæ©å±å±æ§
SELECT
表å = case when a.colorder=1 then d.name else '' end,
表说æ = case when a.colorder=1 then isnull(f.value,'') else '' end,
å段åºå· = a.colorder,
å段å = a.name,
æ è¯ = case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then 'â'else '' end,
ä¸»é® = case when exists(SELECT 1 FROM sysobjects where xtype='PK' and parent_obj=a.id and name in (
SELECT name FROM sysindexes WHERE indid in(
SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid))) then 'â' else '' end,
ç±»å = b.name,
å ç¨åèæ° = a.length,
é¿åº¦ = COLUMNPROPERTY(a.id,a.name,'PRECISION'),
å°æ°ä½æ° = isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0),
å
许空 = case when a.isnullable=1 then 'â'else '' end,
é»è®¤å¼ = isnull(e.text,''),
å段说æ = isnull(g.[value],'')
FROM
syscolumns a
left join
systypes b
on
a.xusertype=b.xusertype
inner join
sysobjects d
on
a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
left join
syscomments e
on
a.cdefault=e.id
left join
sysproperties g
on
a.id=g.id and a.colid=g.smallid
left join
sysproperties f
on
d.id=f.id and f.smallid=0
where
d.name='è¦æ¥è¯¢ç表' --å¦æåªæ¥è¯¢æå®è¡¨,å ä¸æ¤æ¡ä»¶
order by
a.id,a.colorder
温馨提示:答案为网友推荐,仅供参考