create table script for existing table

Question

create table script for existing table

JOSHI, Vivek 0

I want to create a create table script for existing table with indexes

Answer recommended by moderator

2 additional answers

Your answer

Answer 1

Erland Sommarskog 133K MVP Volunteer Moderator

You can also go to Tools->Options and SQL Server Object Explorer->Scripting->Table and View options to select that indexes should be scripted.

Answer 2

JOSHI, Vivek 0

Just right click and Generate Script does not give index details. Hence I will always recommend to use Wizard option - use Task -> Generate Script -> Advanced -> set Index options, triggers to true and then generate the script. The generated script will be the one to be used to create an identical Table or any object as per the source database.

JOSHI, Vivek 0 Reputation points

2026-02-09T22:58:31.9233333+00:00
That's Good to include this alternate method. Thank you.

As mentioned ->

go to Tools->Options and SQL Server Object Explorer->Scripting->Table and View options to select that indexes should be scripted.

set the option as above then go to required table and right click and click on "script table as" -> new window or file etc.
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator

2026-02-17T10:53:53.4766667+00:00

Hi JOSHI, Vivek,

I'm following up to check whether your issue has been resolved. If you still have any questions or need further assistance, please don't hesitate to reach out we're happy to continue supporting you.

We truly appreciate your participation and thank you for being an active member of the community.

Best regards,

Lakshmi
JOSHI, Vivek 0 Reputation points

2026-02-17T20:38:42.7166667+00:00

Hi Lakshmi,

All good. Thank you. Created the script as required.

Vivek
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator

2026-02-20T08:00:06.45+00:00

Hi JOSHI, Vivek,

Thanks for the update.

Thanks,

Lakshmi.

Answer 3

To create a CREATE TABLE script for an existing table in SQL Server, you can use SQL Server Management Studio (SSMS) to generate the script. Here are the steps:

Open SQL Server Management Studio and connect to your database.
In Object Explorer, locate the table for which you want to generate the script.
Right-click on the table and select Script Table as > CREATE To > New Query Editor Window. This will generate the CREATE TABLE script for the selected table, including its structure and indexes.

This method allows you to easily obtain the complete definition of the table, including any indexes that are associated with it.

References:

View the Table Definition

Share via

create table script for existing table

2 additional answers

Your answer