change Constraint

Question

i have change table name but constraint name is old, need to change constraint or any impact if table name is different but constraint name is old table name

Sachin Singh · Answer

Have you faced any issue so far? Table name change will have also updated the apporpriate Metadata in the system catalogs and so the constraint will still be referencing the correct table, so you should not get any trouble.

Aravind Govindaraj · Answer

Basically, it's good to follow the custom naming convention while creating constraints like "UQ_ _ " instead of creating automatically. We faced the same sort of scenario in my previous project. We created a script where it will delete all the auto-created constraint name(s) and with the help of the script you can create exactly the same as previously with the changed table name. The steps we followed while doing this activity Take the existing constraint from the table Store it in a local variable(s) Get the table name and create a format "UQ_ _ " Delete the existing constraint Alter with new constraint Hope this helps you ...

Aradhana Tripathi · Answer

There will be no impact on table data, however the name of constraint may contain text of old table name and it may be confusing in future.

change Constraint

Answers (3)