How to Duplicate a Table in SQL Server
Last updated July 25, 2026 · By the SaturnSQL team
SELECT ... INTO new_table FROM old_table creates and fills the copy in one statement. It copies column names, types, and the IDENTITY property, but not indexes, constraints, defaults, or triggers.
SELECT *
INTO orders_backup
FROM orders;Structure only, no rows
SELECT *
INTO orders_empty
FROM orders
WHERE 1 = 0;Recreate indexes and constraints on the copy afterwards. For an exact clone, script the table definition instead and run it before an INSERT ... SELECT.
Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free