Copying Tables From One Database To Another Database

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: 
  • Account
  • Loan 
  • Depositor
Customer Database Tables:
  • Details
  • Branch
  • Address                
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
Ebook Download
View all
Learn
View all