-------------------------------------------------------------------------------------------
--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