The foreign key construction contains the option on cascade delete. The role of this option is to define the behavior of the tables when deletions occur in the table where the primary key occurs. Namely, when a row is removed from the table containing the primary key and the clause on cascade delete is specified, then all rows from the table that contains the corresponding foreign key that match the removed row are also removed.