If you attempt to delete a record that is being referenced by a foreign key in another table, the DBMS will prevent the deletion to maintain referential integrity. This ensures that no orphan records are left in the child table.