FK - urgent

Hi,

I have a Fk on table1 whose id is mapped to table2
Following FK options are enabled
1.enforce relationship for insert/update
2.cascade update
3. cascade delete

Now when I update a row in table1, data from table 2 is deleted.

This is done through query analyser & not frond end.

why deleted on updating.
Please reply.

Thanks

Quote:

Originally Posted by shubhangi

Hi,

I have a Fk on table1 whose id is mapped to table2
Following FK options are enabled
1.enforce relationship for insert/update
2.cascade update
3. cascade delete

Now when I update a row in table1, data from table 2 is deleted.

This is done through query analyser & not frond end.

why deleted on updating.
Please reply.

Thanks

Based on this information, it is not possible to decide ..at least for me. So plesae post the table struture and the code of the triggers and then I can take a look.