How to parameterize SELECT and FROM tables

Asked Feb 04 '21 at 15:00

Active Feb 04 '21 at 15:03

Viewed 90 times

I have a situation where I need to extract tables from one SQL database into another SQL database. There are about 100+ tables. I would like to create a parameterized script for the SELECT and FROM tables so that the one script can be used to loop through all the tables.

Is this possible? I would really appreciate any assistance.

edited Feb 04 '21 at 15:03

Evaldas Buinauskas

13,739
11
55
107

asked Feb 04 '21 at 15:00

sqlenthusiast

Table definitions and/or table data? – jarlh Feb 04 '21 at 15:04
@jarlh preferably with the table definitions and table data. – sqlenthusiast Feb 04 '21 at 15:06
2

Have you considered using Import/Export feature in SSMS? You also could export your whole database schema using it. – Evaldas Buinauskas Feb 04 '21 at 15:07
@EvaldasBuinauskas I have, but would like to create a generic script that may be re-purposed. – sqlenthusiast Feb 04 '21 at 15:08
1

Does this answer your question? [T-SQL query to show table definition?](https://stackoverflow.com/questions/6215459/t-sql-query-to-show-table-definition) – Amira Bedhiafi Feb 04 '21 at 15:31
Hi @SandraGuilepZouaouiZandeh unfortunately not. Thank you though. – sqlenthusiast Feb 05 '21 at 04:49

How to parameterize SELECT and FROM tables

0 Answers0