Alter Procedure DBo.storedProcedure1AS Select (ss.id, ss.name, 'isidentity') = 1 Ten '1'Else' 0 'end) N' Identifier ', (Case When (Select Count (*) from FROM sysobjects WHERE (name in (SELECT name FROM sysindexes WHERE (id = ss.id) AND (indid in (SELECT indid FROM sysindexkeys WHERE (id = ss.id) AND (colid in (SELECT colid FROM syscolumns WHERE (id = ss. ID) AND (Name = ss.name)))))))))))))))> 0 THEN '1' ELSE '0' end) n 'primary key', ss.colorder n 'field number' (Case when ss.isnullable = 1 THEN '1'ELSE' 0 'end) N' Allows empty ', S.Name as n' table name, ss.name as n 'field name', T.Name As n 'Data Type', ISNULL (ColumnProperty (SS.ID, SS.NAME, 'Scale'), 0) AS N 'Digital number', SS.LENGTH N 'Total bytes', ISNULL (E.TEXT,' ') N' Default ', ColumnProperty (SS.ID, SS.NAME,' Precision ') AS N' Length ', g. [Value] AS N' Field Description 'from sysobjects s left sscolumns ss on sa.id = S.ID Inner Join SystemYpes T on (t.xtype = ss.xtype and t.name <> 'sysname') Inner Join Sysproperties g on (s.id = g.id and ss.colid = g.smallid) Inner Join sysindexkeys Sk on (SK.ID = ss.id and sk.co LID = 1) Left join syscomments eon ss.cdefault = E.id WHERE S.XTYPE = 'u' and s.name <> 'dtproperties' return --by huntfox
