A
adegroff
I have been working with Visio to create my database models, however,
I'm running into some issues with naming standards of my company and I
was wondering if, somehow, I could add to the list of FK Name
Generation options in the Database Modeling Preferences - Logical Misc.
tab.
Our company standards on naming Primary and Foreign Keys is:
PK_TableName
and
FK _Parent_Child
It looks like the only options I have to modify the automatic naming in
Visio is
Parent + Child + Suffix (i.e. TableName_PK or ParentChild_FK)
and subsequent combinations similar to this with the Suffix at the end.
Is there anyway to make the Suffix the "Prefix" besides manually
changing all of the key names (that would take a while)?
I'm running into some issues with naming standards of my company and I
was wondering if, somehow, I could add to the list of FK Name
Generation options in the Database Modeling Preferences - Logical Misc.
tab.
Our company standards on naming Primary and Foreign Keys is:
PK_TableName
and
FK _Parent_Child
It looks like the only options I have to modify the automatic naming in
Visio is
Parent + Child + Suffix (i.e. TableName_PK or ParentChild_FK)
and subsequent combinations similar to this with the Suffix at the end.
Is there anyway to make the Suffix the "Prefix" besides manually
changing all of the key names (that would take a while)?