Copy Table into Other Database in SQL Server

-------------------------------------------------------------------------------------------

--How to copy a table with all filed from the existing database to another database?

--Copying a table from one database to another database in the SQL server
--COPY A TABLE INTO THE OTHER DATABASE IN AN SQL SERVER

Just follow the steps given below:

--Write Click On your Database (Database into which you want to copy)

--Task
--Import

--You will get a window SQL Server Import and Export Wizard (click next)

--Here, write your server name in the Server name column

--And select your database name from where you want to copy and click on the next button

--After that you will get (Chose destination), in this select your database name again into which you want to copy that table and click Next

--Now select the first statement, copy the data from one or more tables or views and Next

-- After that, you will get the numbers of the table, just select the table name that you want to copy and click on the Next button

--Click Next and Finished

--Close

--Refresh your database connection and check your database, you will find that table
Ebook Download
View all
Learn
View all