(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? *****************************************************