MS-SQL Table Description 확인

ALTER PROCEDURE [dbo].[TDESC] (@vTname varchar(50))

AS

BEGIN

   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 outer join sys.types d on (b.system_type_id = d.system_type_id)

   where a.name = upper(@vTname)

   order by a.name, b.column_id

END