Shulou(Shulou.com)06/01 Report--

SELECT (case when a. collation =1 then d.name else null end) table name, a.Colorder field serial number,a.name field name, (case when COLUMNPROPERTY(a.id, a.name,'IsIdentity')=1 then '√'else '' end) identity, (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 (SELECT colid FROM syscolumns WHERE (id = a.id) AND (name = a.name))))))) AND (xtype = 'PK'))>0 then '√' else '' end) Primary key,b.name Type,a.length Number of bytes occupied, COLUMNPROPERTY(a.id,a.name,'PRECISION') as Length, isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) as decimal places,(case when a.isnullable=1 then '√'else '' end) Allow null, isnull(e.text,'') Default,isnull(g. [value],'') AS [DESCRIPTION] 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 sys.extended_properties g on a.id =g.major_id AND a.colid=g.minor_id left join sys.extended_properties f on d.id =f.class and f.minor_id=0 where b.name is not null --WHERE d.name ='Table to query' --If only specified tables are queried, add this condition order by a.id,a.colorder

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.