There are two tables, one is SQL Server Database and another one ORACLE Database. Let it be a Parent and Child Table RelationshipIf you update the Table in ORACLE, how to update the TABLE in SQL Server?

Questions by srinivasan111

Showing Answers 1 - 5 of 5 Answers

cimon

  • Apr 6th, 2006
 

we can use foreign keys as they establish relation between parent and child table and also if any updation or deletion is done in parent table the child table is also done with the changes

  Was this answer useful?  Yes

suresh

  • Jun 20th, 2006
 

assign one table should be foreign key another table should be primary key

  Was this answer useful?  Yes

dinaasruthy

  • Jul 3rd, 2010
 

I think the best way would be to use triggers.  Triggers are used to initiate an event. So when a parent table is updated it will automatically trigger the child table to be updated.  Do let me know whether I am correct.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions