to create unique constraint
ALTER TABLE hikel
ADD CONSTRAINT UQ_ConstraintforHikelLookups UNIQUE (HIKEL_TYPE ,COMP_ID ,BRANCH_ID ,SECTOR_ID ,SECTION_ID,PROJECT_ID);
ALTER TABLE hikel
ADD CONSTRAINT UQ_ConstraintforHikelLookups UNIQUE (HIKEL_TYPE ,COMP_ID ,BRANCH_ID ,SECTOR_ID ,SECTION_ID,PROJECT_ID);
No comments:
Post a Comment