Hi

Is it possible to ALTER the foreign key constraint of an existing
populated table by adding a CASCADE option in the ON UPDATE clause?

Or should i drop the table first and give create table again?

But dropping a table ends up in lots of integrity violations in the
database i use.

Any decent way out?


regards



--
Nataraj S Narayanan
Synergy Info Systems
Kochi,India-683 503
Ph:95 484 557244