Hi friends,
Is it possible to alter an unique index inorder to add the additional column to it, instead of dropping and recreating it.
Currently i have an index with the below stmt create stmt
CREATE UNIQUE INDEX PK_D_REG_CAND_SYL_DIMENSION ON BEC_DW_NEW.D_REG_CAND_SYL_DIMENSION
(FK_QUALIFICATION_ID, FK_SERIES_ID, FK_CANDIDATE_MST_ID, FK_SYLLABUS_ID, FK_DIMENSION_TYPE_ID)
Now i need to add an extra column to the above (i.e) PK_CAND_SYLLABUS_DIMENSION_ID. Is it possible to alter the above index to include the additional columns.
Will the below stmt help
ALTER INDEX PK_D_REG_CAND_SYL_DIMENSION ADD PK_CAND_SYLLABUS_DIMENSION_ID
Thanks in advance.
Regards,
Saro