How to create duplicate table in mysql

Applies to: SQL Server 2016 (13.x) and later Azure SQL DatabaseAzure SQL Managed InstanceAzure Synapse AnalyticsAnalytics Platform System (PDW)SQL database in Microsoft Fabric

You can duplicate an existing table in SQL Server by using SQL Server Management Studio or Transact-SQL by creating a new table and then copying column information from an existing table.

These steps described duplicate only the structure of a table, not the row data.

Permissions

Requires CREATE TABLE permission in the destination database.

Use SQL Server Management Studio

To duplicate a table

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.

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

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

4. Select the columns in the existing table and, from the Edit menu, select Copy.

5. Switch back to the new table and select the first row.

6. From the Edit menu, select Paste.

7. From the File m

   replicate table in sql
   copy table in sql without data