Get a list of table and column names created in the database
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 t.name as table_name ,c.name as column_name from sys.tables as t inner join sys.columns as c on c.object_id = t.object_id order by t.name, c.object_id
The results are displayed as follows: