SQL Server Express : clone table with a different index but without data

Question

I have a SQL Server table with several columns, an index starting from 1 as primary key.

Now I need to clone this table but without the data and with a different index, let's say starting from 100 000. I have never done this before so I am quite unsure about how to do it. I know how to create a new table,

CREATE TABLE new_table
AS (SELECT * FROM old_table);

but I do not know how to start the index from 100 000 and clone it without the data from the original table keeping the structure and the datatype exactly the same. Some help will be appreciated.

I am using SQL Server 2012 Express that came with Visual Studio 2012.

Which database are you using ?

Ashish Gaur
– Ashish Gaur

2013-09-11 11:35:38 +00:00
Commented Sep 11, 2013 at 11:35 — Ashish Gaur
– Ashish Gaur, Commented Sep 11, 2013 at 11:35

Ajay · Accepted Answer · 2013-09-11 12:55:29Z

1

SQL Server does not support CREATE TABLE AS SELECT.

Use this

SELECT  *
INTO    new_table
FROM    old_table

or

SELECT TOP 0 * INTO new_table FROM old_table

answered Sep 11, 2013 at 12:55

Ajay

6,59818 gold badges83 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marc_s · Accepted Answer · 2013-09-11 11:40:20Z

1

Try this

CREATE TABLE new_table AS SELECT TOP 0 * FROM old_table

edited Sep 11, 2013 at 11:40

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 11, 2013 at 11:40

muthuraman

212 bronze badges

1 Comment

muthuraman Over a year ago

try this SELECT TOP 0 * INTO newTable FROM OldTable

muthuraman · Accepted Answer · 2013-09-11 12:49:25Z

1

try this SELECT TOP 0 * INTO newTable FROM OldTable

answered Sep 11, 2013 at 12:49

muthuraman

212 bronze badges

1 Comment

FeliceM Over a year ago

You should give only one answer and/or eventually update your own one not post double. However thanks but the first one did not work.

Collectives™ on Stack Overflow

SQL Server Express : clone table with a different index but without data

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related