[DB] Apply unique constraint to a table

Apply unique constraint

ALTER TABLE [table name] ADD CONSTRAINT [constraint name] UNIQUE (column1, column2, ... columnN);

 

Example

 

ALTER TABLE my_table ADD CONSTRAINT name_id_constraint UNIQUE (name, id);