title: script Table as Create via SSMS doesn't show unique index
body: <p>Using SQL Server Management Studio 2008, why can't I see unique index ( not primary key ) when I generate Create Table SQL code?</p>
  
  <p>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.</p>