T-SQL script -List columns and attributes for every table in a SQL Server database

 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] 
 FROM sys.[tables] AS T 
 INNER JOIN sys.[all_columns] AC ON T.[object_id] = AC.[object_id]
 INNER JOIN sys.[types] TY ON AC.[system_type_id] = TY.[system_type_id]
                                              AND AC.[user_type_id] = TY.[user_type_id]  
 WHERE T.[is_ms_shipped] = 0 
 ORDER BY T.[name], AC.[column_id]

Reference : Pinal Dave (http://blog.SQLAuthority.com)

See Also:

• T-SQL Scripts