Question

What is the query to create another table with the same structure of employee table along with the data?

Answer 1

Make sure you are connected to the database in which you want to create the table and that the database is selected in Object Explorer.

In Object Explorer, right-click Tables and click New Table.

In Object Explorer right-click the table you want to copy and click Design.