SQL Server methods for copying one table from one database to another

In two steps:

The first step is to duplicate the table structure:

Right-click on the table to write a table script:-->create to the New Query Editor window, you can also save as a SQL file,

Change the top sentence of the New Query Editor window to "Newdatabase" in the "Olddatabase" in use [Olddatabase], where olddatabase is the source database name, Newdatabase is the target database name, click on the " Execute button so that the table structure is copied;

The second step is to copy the table data:

Right-click on the "Olddatabase" and export the data, select the source database, authentication and target database, and after authentication in the popup dialog.

Then select the table you want to copy, and when you are done, the table data is copied successfully.