Alter Procedure getDatabaseInfo9
Asselect (case when b.colorder = 1 or b.colorder is null dam, as n 'table name, B.Name As n' field name, (Case When c.name is null dam '' Else C.Name End AS N 'Data Type', B.PREC AS N 'Length', (Case When B.colstat = 4 Then '√'lse' 'End) N' Whether Output ', B.ColORDER N 'field number', (Case When B.Colorder = 1 or b.colorder is null kiln text else '' end) AS N 'content' from sysobjects a left join syscolumns b on b.id = a.id Left Join systemypes c on (c.XTYPE = B.XTYPE AND C.NAME <> 'sysname') LEFT JOIN SYSCOMMENTS D on D.ID = a.id Where (a.schema_ver = 0 or A.SCHEMA_VER = 48) And A .XTYPE = 'p' Order by a.name, B.ColORDER RETURN
