Erwin Constraint명, Index(PK, AK, ...)명 변경하기

Erwin 상단의

Menu > Tools > Names > Model Naming Options

Macro Name에 아래와 같이 추가

Relationships : FK_%Child
Key Group to Index : %If(%==(%Substr(%KeyType,1,2),IN)){IX_%TableName}%If(%==(%Substr(%KeyType,1,2),IE)){IX_%TableName_01}%If(%==(%Substr(%KeyType,1,2),AK)){UIX_%TableName}%If(%==(%Substr(%KeyType,2,1),F)){FK_%TableName_0%Substr(%KeyType,3,1)}%If(%==(%KeyType,PK)){PK_%TableName_01}

 

결과 :

ALTER TABLE #### ADD CONSTRAINT  PK_####_01 PRIMARY KEY (####, ####);

ALTER TABLE #### ADD (CONSTRAINT FK_####_01 FOREIGN KEY (####) REFERENCES #### (####));