Archive
Posts Tagged ‘PowerDesigner’
|
|
I have faced a problem, few weeks ago, someone made the reverse from a huge DB to Power Designer 12.5, something with more than 100 tables… ( huge for me of course ) I had to change the name of the FKs (References), Sequences, Trigger and Columns putting in the pattern requested, but the names was recieving more than 30 Chars. To verify that without checking one-by-one I made a “Extend Model Definition” , below you will see what I made, maybe this could help you in the future.
For References I used, this script is:
| 1 | FUNCTION %Check%(obj) | | 2 | %Check% = True | | 3 | IF (len(obj.ForeignKeyConstraintName)>30) Then | | 4 | %Check% = false | | 5 | end IF | | 6 | End FUNCTION |
For Sequences I used, this script is:
| 1 | FUNCTION %Check%(obj) | | 2 | <obj> %Check% = True | | 3 | IF (len(obj.Code)>30) Then | | 4 | %Check% = false | | 5 | end IF | | 6 | End Function</obj> |
For Table I used, this script:
| 1 | FUNCTION %Check%(obj) | | 2 | %Check% = True | | 3 | IF (len(obj.name)>30) Then | | 4 | %Check% = false | | 5 | end IF | | 6 | End FUNCTION |
And for Trigger, I used:
Function %Check%(obj)
| 1 | %Check% = True | | 2 | IF (len(obj.name)>30) Then | | 3 | %Check% = false | | 4 | end IF | | 5 | End FUNCTION |
|
Recent Comments