How to add/drop unique constraint to an oracle table Posted by By sunny.bak March 16, 2022Posted inORACLE How to add a constraint (in this case unique constraint) to an existing table ALTER TABLE mytable ADD CONSTRAINT user_role_uq UNIQUE (name, role); How to remove a constraint from an…