var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete script
I am having a customer linked to many tables like card,account,bank etc .How can i delete all the related data of a particular customer in single query?
Can anyone pleasse give me some hint ?
You cannot do it is a "single" statement--unless all of your RI is setup up to do it for you. You can however do it in an atomic block of statements:
--Turn off autocommit if it is on
Delete from all child tables in the proper order
delete from parent table
--Turn on autocommit if applicable