Deepak Ratan

Deepak Ratan

  • NA
  • 175
  • 50.6k

Copy tables from one database to another in SQL Server

Jun 18 2015 3:39 AM
Copy tables from one database to another in SQL Server
 
I have a database called FirstDatabase and a database called SecondDatabase. I have a 40 table's in FirstDatabase  that I want to COPY (data and all)  from FirstDatabase to SecondDatabase. What is the SQL statement to do this? 

Answers (4)