cancel
Showing results for 
Search instead for 
Did you mean: 

How to customize generated FK name to include FK columns?

Former Member
0 Kudos

I'm new in PowerDesigner and still learning it. I know I can customize the generated FK name from below:

http://i.imgur.com/KOd5o68.png

However, I don't know how customize it to include the FK columns in it.

For example, let's say I have a table:

create table test

(

id int primary key,

fk1 int,

fk2 int

)

and I have FK on fk1 and fk2 columns. The name I want is FK_test_fk1_fk2 (fixed string FK plus table name plus all FK column names). How can I change the ConstName Value to make all this happen?

Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member217396
Participant
0 Kudos

I'm not sure, there is such a variable to allow you to concatenate all the fk attributes...

You can do it using a extension for your model, like this:

HTH,

Rafal