-- Add a Unique constraint and deifine the constraint name ALTER TABLE TABLENAME ADD CONSTRAINT UQ_tblPerson_Email UNIQUE(COLUMN_NAME)