Saturday, September 19, 2015

sql server unique constraint

to create unique constraint

ALTER TABLE hikel
   ADD CONSTRAINT UQ_ConstraintforHikelLookups UNIQUE (HIKEL_TYPE ,COMP_ID ,BRANCH_ID ,SECTOR_ID ,SECTION_ID,PROJECT_ID);