Nataraj S Narayanan schrieb:

>
> 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?

You can drop the constraint and recreate it with the CASCADE option.
For that action you don't have to drop any table!

Luc.