Rename constrain name or index name.
695262Mar 14 2012 — edited Mar 14 2012When you change an index name, or a constrain name, and then, you want to sincronize the relational model with the data dictionary, the generated DLL(delta),
use drop index, and create index.
This will not work in certain scenarios like unique index name, due to the fact that you can not delete unique index.
It is posible that instead of making drop create index, just make a rename statement?
Thanks in advance.
IEg:
INSTEAD OF:
DROP INDEX schema_name.index_name
;
CREATE UNIQUE INDEX shcema_name.new_index_name ON schema_name.table_name
DO:
ALTER TABLE schema_name.table_name
RENAME CONSTRAINT schema_name.index_name
TO shcema_name.new_index_name;