[Excluded indexes] Index on a local temp table Clustered index [Other restrictions] Only one subclause is allowed at a time. For example, you cannot add and drop PRIMARY KEY or UNIQUE constraints in the same ALTER TABLE statement. [Online index operation] 
ALTER TABLE ADD CONSTRAINT (PRIMARY KEY or UNIQUE)