CODE EXAMPLE FOR SQL

clustered-nonclustered indexes(constraints)

/* Clustered index */
ALTER TABLE MyTable
    ADD CONSTRAINT PK_MyTable
        PRIMARY KEY(WidgetId);
 
/* Clustered index */  
ALTER TABLE MyTable
    ADD CONSTRAINT PK_MyTable
        PRIMARY KEY CLUSTERED(WidgetId);
 
/* Non-clustered index */  
ALTER TABLE MyTable
    ADD CONSTRAINT PK_MyTable
        PRIMARY KEY NONCLUSTERED(WidgetId);
 
 
/* Non-clustered index */  
ALTER TABLE MyTable
    ADD CONSTRAINT UC_MyTable_WidgetNumber
        UNIQUE(WidgetNumber);
 
/* Non-clustered index */  
ALTER TABLE MyTable
    ADD CONSTRAINT UC_MyTable_WidgetNumber
        UNIQUE NONCLUSTERED(WidgetNumber);
 
/* Clustered index */  
ALTER TABLE MyTable
    ADD CONSTRAINT UC_MyTable_WidgetNumber
        UNIQUE CLUSTERED(WidgetNumber);