erwin index 명 설정

erwin index 명 설정 * Menu > Tools > Names > Model Naming Options   * Name Mapping Tab에서 ObjectType 가  Key Group to Index 인 MacroName (%KeyName)부분을 변경   * 스크립트 변경   IDX_%If(%==(%IndexType,PK)){%TableName_PK}%Else{%IF(%==(%substr(%IndexType,1,2),IF)) {%TableName_%substr(%IndexType,2)}}   적용 예) tablename : SELF_TEST CREATE UNIQUE INDEX IDX_SELF_TEST_PK ON SELF_TEST (SELF_TEST_SEQ); ALTER TABLE SELF_TEST_DVC_MNG ADD CONSTRAINT  IDX_SELF_TEST_PK PRIMARY KEY (SELF_TEST_SEQ);   %If(%==(%Substr(%KeyType,1,2),IE)){IX}%If(%==(%Substr(%KeyType,1,2),AK)){UIX}%If(%==(%KeyType,PK)){PK}_%TableName%If(%Not(%==(%KeyType,PK))){_%Substr(%KeyType,3,1)}   적용 예) CREATE UNIQUE INDEX PK_SELF_TEST ON SELF_TEST (SELF_TEST_SEQ);   ALTER TABLE SELF_TEST ADD CONSTRAINT  PK_SELF_TEST PRIMARY KEY (SELF_TEST_SEQ) [출처] erwin index 명 설정|작성자 쩡동