Auto Numbering of Objects

[Lucy Rossano]

I want to know if there is a way to append a sequential number to an
object's name within both the DBMS definition or an extension to a
model.
An example of what I want to do is if I have multiple alternate keys
defined on a table, I want the DDL to generate

Table_AKn
such that I would have
Table_AK1
Table_AK2 as the constraint names generated.

Anyone know how or if I can do that?

Kinda new to PowerDesigner customizations.

[rkkier]

I'd guess you can, but when I originally looked at it, I decided it was more code than it was worth.

Where possible, I've changed or AK standards to match something PowerDesigner does more easily. Where I couldn't, I put a custom check on the table, with autocorrect that goes through and sets them all using vbscript. It was simpler to do, and as long as you're diligent in performing a check model, you're good. If I get a chance, I'll post the code, but maybe someone has tweaked the key name gtl to do exactly what you want.