MS SQL Generate Database Schema

INFORMATION_SCHEMA is a quick way to get around a database.

Hope this helps.

Generate list of all table and columns in the table.

Select *
From INFORMATION_SCHEMA.COLUMNS
Where TABLE_CATALOG Like 'SupportCenter' ORDER BY TABLE_NAME

Generate list of all columns in a table.

Select *
From INFORMATION_SCHEMA.COLUMNS
Where TABLE_CATALOG Like 'SupportCenter' And TABLE_NAME Like 'Software'