Обсуждение: how to add "on delete cascade" to a foreign key constraint?

Поиск
Список
Период
Сортировка

how to add "on delete cascade" to a foreign key constraint?

От
A B
Дата:
Hello.

I have a table with a foreign key constraint, how can I add "on delete
cascade" to the foreign key?

Re: how to add "on delete cascade" to a foreign key constraint?

От
Tom Lane
Дата:
A B <gentosaker@gmail.com> writes:
> I have a table with a foreign key constraint, how can I add "on delete
> cascade" to the foreign key?

You can't --- just drop the constraint and add a new one.

            regards, tom lane