On the same server, how to completely copy a table in library A to library B

damagebandit

On the same server, how can I completely copy a table tblrsxx from the A library to the B library.

小老鹰

Just use the DTS import wizard.
Note that select "Copy objects and data between SQL Server databases" and "Include extended attributes".

恶魔右指

A library backup, named B library when restoring with backup

tutuzhu

Use sql query analyzer, in the "Object Browser" on the left, select the table to copy the format, right-click the table name, and select "write object script in new window-> create"



Add a use B library name before create table ..........

as follows:

use B library name
create table ..........

githzerai

With the import and export function of DTS, select the third line "Copy objects and data between SQL Server databases" and tick "Include extended attributes".