Saturday, 24 September 2016

Comma Separated Columns & Table Name To All Data Base


SELECT OBJECT_SCHEMA_NAME(T.[object_id], DB_ID()) AS [Schema], T.[name] AS [table_name], AC.[name] AS [column_name], TY.[name] AS system_data_type, AC.[max_length], AC.[precision], AC.[scale], AC.[is_nullable], AC.[is_ansi_padded], AC.* FROM sys.[tables] AS T LEFT JOIN sys.[all_columns] AC ON T.[object_id] = AC.[object_id] LEFT JOIN sys.[types] TY ON AC.[system_type_id] = TY.[system_type_id] AND AC.[user_type_id] = TY.[user_type_id] WHERE 1 = 1 AND AC.[max_length] = -1 ORDER BY T.[name], AC.[column_id]

No comments:

Post a Comment