When I RE Oracle 9i with “Don’t load system generated names …” option selected, TDM generates names. These are of the form NN_
Please find attached a script that should help you.
Run the script in Scripting Window (Tools menu).
The script will go through all NotNull attributes and will set their notnull constraint name in format NN_nameoftable_number. For names exceeding 30 characters, it will truncate the NN_nameoftable part.
Malcom, please let us know whether the script meets your requirements. Thanks in advance.
Vladka + Mario
Rename_NN_Constraint_Name.zip (629 Bytes)
That seems to do what we require. Many thanks. Malcolm
Great! Thanks for letting us know.
I’ll add the script to the Scripts section (Library).
Have a nice weekend!
Just a quick note: The script, including description + instructions on how to execute it, is available at: