Get All Tables & Its Column Name of a DB

select T2.name as 'TableName',T1.name as 'ColumnName' from sys.columns T1 inner join sys.tables T2 on (T1.object_id = T2.object_id) order by TableName