ʹÓÃSQLÓï¾äÉú³ÉÊý¾Ý×Öµä

--sqlserver 2000
SELECT ±íÃû=case when a.colorder=1 then d.name 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 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.xtype=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
order by a.id,a.colorder
--sqlserver 2005
SELECT Sysobjects.name AS TABLE_NAME, syscolumns.Id, syscolumns.name AS COLUMN_NAME,
        systypes.name AS DATA_TYPE, syscolumns.length as CHARACTER_MAXIMUM_LENGTH,
        sys.extended_properties.[value] AS COLUMN_DESCRIPTION,  
        syscomments.text as COLUMN_DEFAULT,syscolumns.isnullable as IS_NULLABLE
   from syscolumns
INNER JOIN systypes  
          ON syscolumns.xtype = systypes.xtype
LEFT JOIN sysobjects ON syscolumns.id = sysobjects.id
LEFT OUTER JOIN sys.extended_properties
               ON ( sys.extended_properties.minor_id = syscolumns.colid
              AND sys.extended_properties.major_id = syscolum