Modify foreign key

In Oracle, you can really modify it with ALTER TABLE MODIFY CONSTRAINT.

In SQL Server or most of other DBs, there's no such statement. you have to drop the constrain the first, recreate it the next.

Oracle might do the same two steps way beneath the scene.