T-SQL List Tables, Columns

Please check out the information schema.

select *
from MyDatabaseName.information_schema.columns
order by table_name, ordinal_position