Showing posts with label unique. Show all posts
Showing posts with label unique. Show all posts

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);