DIR Return Create A Forum - Home
---------------------------------------------------------
ExcelSoft Database Professionals
HTML 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
gopher.createaforum.com:70 /forums/esdbp/p/81:31: port field too long