Get a list of table and column names created in the database

Page update date :
Page creation date :

Normally, you would put table or column names in SQL and SELECT or INSERT, but you can also get the names of tables and columns created in the data base in SQL. If you can do this, you can create dynamic SQL that automatically follows the growth of tables and columns.

To get a list of table and column names, SQL looks like this: More information is available, but the configuration is minimal here.

select as table_name
 , as column_name
from sys.tables as t
inner join sys.columns as c
  on c.object_id = t.object_id
order by, c.object_id

The results are displayed as follows: