ALTER TABLE table_name ADD CONSTRAINT cst_name UNIQUE (col_name); ALTER TABLE table_name ADD CONSTRAINT cst_name UNIQUE (col1, col2); -- Multiple ALTER TABLE table_name ADD col_name NUMBER UNIQUE; -- New field