Post reply

Erwin Naming Standard

  • November 8, 2004 at 2:29 am

    #163065

    Hi,

    I'm using Erwin 4.0 to create the design for one of our products here. But I'm facing a problem in enforcing naming standards to the Forgien key.

     

    Regards,

    Jomy John Thomas

    Your Guide to Admin and Design

  • November 9, 2004 at 8:22 am

    #529461

    Do you mean enforcing the name or automatically naming the FKs?

  • November 9, 2004 at 8:24 pm

    #529544

    Hi,

    I want to automatically Name the Fk

    as Fk_ChildTable$ChildColumn_ParentTable%ParentColumn

    Regards,

    Jomy John Thomas

    Your Guide to Admin and Design

  • November 9, 2004 at 11:50 pm

    #529555

    Finaly I got it working after some 12 hours of research on all the various combinations of macros.

    %ForEachEntity{%ForEachChildRel(){%ForEachFKAtt() {

    ALTER TABLE %Child

    ADD CONSTRAINT FK_%EntityName(%Child)$%AttName_%EntityName(%Parent)$%ParentAtt(%AttName) FOREIGN KEY(%ChildFK()) REFERENCES %Parent(%ParentAtt(%ColName))}

    %DBMSDelim

    }}.

     

    Regards,

    Jomy John Thomas

    Your Guide to Admin and Design

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply