CASCADE

If the cascade is used in an On DELETE any orphaned referenced rows will also be deleted

CREATE TABLE Orders 
( 
   ProductID INTEGER References Products(ProductID) ON DELETE CASCADE 
)

If a row is updated in the Products table then the referenced rows in the Orders table will also be updated