테이블정보 조회

SELECT
     OBJECT_NAME(c.object_id)     "Table_Name"
   , c.name                       "Column_Name"
   , c.column_id                  "No."
   , TYPE_NAME(c.system_type_id)  "Type Name"
   , c.max_length                 "Size"
   , c.is_identity                "Identity"
   , c.is_nullable                "Allow_Null"
   , ex.value                     "Description"
FROM
   sys.columns c
LEFT OUTER JOIN
   sys.extended_properties ex
ON      ex.major_id = c.object_id
   AND ex.minor_id = c.column_id
   AND ex.name = 'MS_Description'
WHERE
   OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0
   -- AND OBJECT_NAME(c.object_id) = 'your_table'
ORDER
   BY OBJECT_NAME(c.object_id), c.column_id