Menu
Using SQL Server Management Studio 2008, why can't I see unique index ( not primary key ) when I generate Create Table SQL code?
It includes only primary key constraint. Is it by design ? There is a possibility to get SQL code for index creation via right mouse click on an index and "Script index as", but it is another step.
272
Right-click the table on which you want to create a unique index and select Design. On the Table Designer menu, select Indexes/Keys. In the Indexes/Keys dialog box, click Add. Select the new index in the Selected Primary/Unique Key or Index text box.
We know that the unique constraint in SQL Server creates a unique SQL Server index as well. SQL Server allows us to disable an index as well without dropping it.
Is the "Script Unique Keys" option set to TRUE in your SSMS?
In SSMS, Tools -> Options will get you to the pop-up window shown below. 
100
Note that in SSMS 2012, you have to set "Script indexes" to TRUE to script out unique indexes.
21
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
