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