How to Update the primary key of table which is referenced as foreign key in another table?
- by Mobin
Suppose a
Table "Person" having columns "SSN","Name","Address"
and another
Table "Contacts" having "Contact_ID","Contact_Type","SSN"(primary key of Person)
similarly
Table "Records" having "Record_ID","Record_Type","SSN"(primary key of Person)
Now i want that when i change or update SSN in person table that accordingly changes in other 2 tables.
If anyone can help me with a trigger for that
Or how to pass foreign key constraints for tables