script Table as Create via SSMS doesn't show unique index

Using SQL Server Management Studio 2008, why can't I see unique index ( n开发者_Go百科ot 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.

---

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.

---

Note that in SSMS 2012, you have to set "Script indexes" to TRUE to script out unique indexes.