Bernhard S
Member³
When you rename a constraint or an index in the "Edit table" window and you check out the resulting sql, you can see that PSD does the change via drop/recreate of the constraint/index.
However since Oracle 9i PSD should better use the following renaming sql syntax:
ALTER TABLE test RENAME CONSTRAINT test1_pk TO test_pk;
ALTER INDEX test1_pk RENAME TO test_pk;
This also avoids problems with depending objects like FKs on these PKs.
The same applies to the resulting SQL from "Compare User Objects".
However since Oracle 9i PSD should better use the following renaming sql syntax:
ALTER TABLE test RENAME CONSTRAINT test1_pk TO test_pk;
ALTER INDEX test1_pk RENAME TO test_pk;
This also avoids problems with depending objects like FKs on these PKs.
The same applies to the resulting SQL from "Compare User Objects".
