PostgresSQL Cascade Delete Example [How To]

Описание

In this video tutorial, we show you how in PostgreSQL do a delete cascade using.dbeaver. Code sample is in the description.


Example Delete Cascade;


ALTER TABLE public."NotificationMessage"
DROP CONSTRAINT "fk8a792bf4de1af222",
ADD CONSTRAINT "fk8a792bf4de1af222"
FOREIGN KEY ("certificationfulfillment_id")
REFERENCES "CertificationFulfillment"(id)
ON DELETE CASCADE;