When parent (Student) table undergo deletion operation, tableHSSElectivesAllocationshould also delete all rows that refer to parent table code example

Example: on delete of foreign key delete corresponding rows in other table

ALTER TABLE ReferencingTable DROP 
   CONSTRAINT fk__ReferencingTable__MainTable;

ALTER TABLE ReferencingTable ADD 
   CONSTRAINT fk__ReferencingTable__MainTable 
      FOREIGN KEY (pk_col_1)
      REFERENCES MainTable (pk_col_1)
      ON DELETE CASCADE;

Tags:

Misc Example

Related