MS SQL: List All Columns in all Tables

Modified on Thu, 31 Jul at 3:04 PM

SELECT  tables.name AS table_name,
        all_columns.name AS column_name,   
        types.name AS system_data_type
FROM sys.tables
 INNER JOIN sys.all_columns ON tables.object_id = all_columns.object_id  
 INNER JOIN sys.types ON all_columns.system_type_id = types.system_type_id AND all_columns.user_type_id = types.user_type_id   
WHERE tables.is_ms_shipped = 0  
ORDER BY tables.name, all_columns.name