Search code examples
sql-server

Move a table from one database to another database SQL Server

I have a database DB_1 which has an empty table T1 with 5 columns.

I want to move this table to another database DB_2 on the same SQL Server.

I have tried to use this command:

alter table DB_1.T1 rename DB_2.T1

but this showing error.

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'rename'.

Please help.

Solution

  • If the databases are on same server then do it like this,

    select * into DB_2.T1 from DB_1.[dbo].[T1]

    if you have databases on different servers than you have to create a linked server.

    On second thought you can generate "create tables scripts" and run them on second database