SunnyDB

ALTER PROCEDURE [dbo].[TDESC] (@vTname varchar(50))ASBEGIN select a.name TABNAME, b.NAME COLNAME, d.name CTYPE, b.max_length STRLEN, LTRIM(Str(b.precision)) + ',' +LTRIM(Str(b.scale)) NUMLEN, c.VALUE ADESC from sys.all_objects a left outer join sys.all_columns b on (a.object_id = b.object_id) left outer join sys.extended_properties c on (b.object_id = c.major_id and b.column_id=c.minor_id) left ..