ALTER TABLE ttab DROP CONSTRAINT IF EXISTS unq_ttab; CREATE UNIQUE INDEX unq_ttab_1 ON ttab (partition_num, id); ALTER TABLE ttab ADD CONSTRAINT unq_ttab UNIQUE (partition_num, id);