 |
Return Create A Forum - Home |
 |
--------------------------------------------------------- |
|
ExcelSoft Database Professionals |
 |
https://esdbp.createaforum.com |
|
--------------------------------------------------------- |
|
***************************************************** |
|
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? |
|
***************************************************** |
