CODEWITHSUNDEEP
sql-server
Dan
Dan

Reputation: 45762

Duplicate a table including indexes

Is there a way to duplicate a table in SQL-Server? Not just the data like SELECT INTO does but also indexes and maybe keys as well? If I go script table as -> create to it leaves off my index.

If this functionality is not available, why not?

I'm sure this question must have been asked 1000 times but I couldn't find a SQL-Server duplicate, only MYSQL which has CREATE LIKE but SQL-Server doesn't seem to.

Upvotes: 2

Views: 158

Answers (2)

Kenneth Fisher
Kenneth Fisher

Reputation: 3822

First go to Tools-> Options. Then go to SQL Server Object Explorer, Scripting. From here you will see all of the scripting options, including creating indexes. Creating indexes is turned off by default for some reason but you can turn it on easily enough.

enter image description here

After this then you can right click on the Script Table - Create to ...

enter image description here

And you should now get your indexes.

Upvotes: 1

Kermit
Kermit

Reputation: 34062

Just generate a CREATE script in SQL Server Management Studio. This will also include the indexes.

See this dba.se question

Upvotes: 0

Related Questions