How to create duplicate table with new name in SQL Server 2008

Question

How do I create a duplicate table with only the structure duplicated with a new name in SQL server 2008   I have table with 45 fields so I want to create new with same structure but new name

User · Answer

To create a new table from an existing table: (copying all rows from Old_Table into de New_Table):

SELECT * INTO New_table FROM  Old_Table

To copy the data from one table to another (when you have already created them):

Insert into Table_Name2 select top 1 * from Table_Name1

Remember to remove the top 1 argument and apply a relevant where clause if needed on the Select

User · Answer

Here  I will show you 2 different implementation   First   If you just need to create a duplicate table then just run the command   SELECT top 0   INTO  dbo   DuplicateTable  FROM  dbo   MainTable    Of course  it doesn t work completely  constraints don t get copied  nor do primary keys  or default values  The command only creates a new table with the same column structure and if you want to insert data into the new table   Second  recommended    But If you want to duplicate the table with all its constraints  amp  keys follows this below steps    Open the database in SQL Management Studio  Right-click on the table that you want to duplicate  Select Script Table as -  Create to -  New Query Editor Window  This will generate a script to recreate the table in a new query window  Change the table name and relative keys  amp  constraints in the script  Execute the script

User · Answer

SELECT   INTO newtable FROM oldtable where 1 2  Where 1 2 is used when you need to copy the complete structure of a table without copying the data   SELECT   INTO newtable FROM oldtable   To create a table with data you can use this statement

User · Answer

SELECT   INTO table2 FROM table1

User · Answer

In SSMS right click on a desired table  gt  script as  gt  create to  gt  new query -change the name of the table  ex  table2  -change the PK key for the table  ex  PK table2  USE  NAMEDB  GO SET ANSI NULLS ON GO  SET QUOTED IDENTIFIER ON GO  CREATE TABLE  dbo   table 2    id   int  NOT NULL   name   varchar  50  NULL  CONSTRAINT  PK table 2  PRIMARY KEY CLUSTERED     reference  ASC  WITH  PAD INDEX   OFF  STATISTICS NORECOMPUTE    OFF  IGNORE DUP KEY   OFF  ALLOW ROW LOCKS   ON   ALLOW PAGE LOCKS   ON   OPTIMIZE FOR SEQUENTIAL KEY   OFF  ON  PRIMARY    ON  PRIMARY  GO

User · Answer

My SQL Server Management Studio keeps asking me how I can make it better  I have an idea  The ability to highlight a table and then  ctrl C  ctrl V  would be great and the answer to this question at the same time

User · Answer

I have used this query it is created new table with existing data   Query   select   into  newtablename  from  existingtable    Here is the link Microsoft instructions  https   docs microsoft com en-us sql relational-databases tables duplicate-tables view sql-server-2017

User · Answer

Right click on the table in SQL Management Studio   Select Script     Create to     New Query Window   This will generate a script to recreate the table in a new query window   Change the name of the table in the script to whatever you want the new table to be named   Execute the script

User · Answer

SELECT    INTO target FROM  source WHERE 1   2

[sql] How to create duplicate table with new name in SQL Server 2008

Examples related to sql

Examples related to sql-server

Examples related to tsql

Examples related to sql-server-2008