<Ul> <Li> CASCADE </Li> <Li> RESTRICT </Li> <Li> NO ACTION </Li> <Li> SET NULL </Li> <Li> SET DEFAULT </Li> </Ul> <P> Whenever rows in the master (referenced) table are deleted (or updated), the respective rows of the child (referencing) table with a matching foreign key column will be deleted (or updated) as well . This is called a cascade delete (or update). </P> <P> A value cannot be updated or deleted when a row exists in a referencing or child table that references the value in the referenced table . </P> <P> Similarly, a row cannot be deleted as long as there is a reference to it from a referencing or child table . </P>

What is foreign key and primary key in dbms