I am going to explain how to copy table from one
database to other database with an example as shown below.
Example: Suppose there are two
Databases Bank Database and Customer Database and the table
description for the two database and their tables are as follows.
Bank Database Tables:
Customer Database Tables:
If you want to copy Branch Table From
Customer DB To Bank DB then write the following query:
SQL Query:
Select * INTO Bank.dbo.Branch
From Customer.dbo.Branch
Now, Branch table from customer DB will
be copied to Bank DB