(DIR) Return Create A Forum - Home
       ---------------------------------------------------------
       ExcelSoft Database Professionals
 (HTM) https://esdbp.createaforum.com
       ---------------------------------------------------------
       *****************************************************
 (DIR) Return to: Scripts
       *****************************************************
       #Post#: 88--------------------------------------------------
       Column Meta Data Script
       By: srinivasma_exceldbp Date: November 4, 2014, 12:00 am
       ---------------------------------------------------------
       -- Column Meta Data Script
       SELECT
       s.name as schema__name
       , T.name AS table__name
       , C.name AS column__name
       , C.is_identity
       , Y.name AS data__type
       , C.is_nullable
       , C.max_length
       , C.PRECISION
       , C.scale
       , C.collation_name
       , Y.is_user_defined
       , C.is_ansi_padded
       , C.is_rowguidcol
       , C.is_computed
       FROM sys.tables T
       INNER JOIN sys.columns C
       ON T.object_id
       INNER JOIN sys.types Y
       ON C.system_type_id
       AND C.user_type_id
       INNER JOIN sys.schemas S
       ON S.schema_id
       WHERE T.name
       AND S.name
       ORDER BY C.column_id;
       #Post#: 157--------------------------------------------------
       Re: Column Meta Data Script
       By: Vinoth_K_exceldbp Date: May 18, 2015, 8:05 am
       ---------------------------------------------------------
       Hi,
       We already have sp_help  for this purpose. Whats the use of this
       script then? Any specific advantage?
       *****************************************************