Thread: Script Create Table With Indexes - MS SQL

Script Create Table With Indexes - MS SQL

In SQL Management Studio if you
right click on a table > click on Script Table As > Click on the Create > Click on File/Clipboard... option
you won't get the indexes on the script to carry over.

Solution:
Right click on database
Tasks
Generate Scripts
Click Next
Choose database
On the Choose Script Options window under Table/View Options set Script Indexes to true
Click Next
......