When this key word is included in the definition of a child table then whenever the records from the parent table is deleted automatically the corresponding values in the child table will be deleted.