[Online index operation] ALTER TABLE ADD CONSTRAINT (PRIMARY KEY or UNIQUE) [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. [Excluded indexes] 
Index on a local temp table Clustered index