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