How to write query to Delete the records in child table
and corresponding records in parent table
Answer Posted / arijitnit
delete from child_table where values=...
on delete cascade..
U have to set the foreign key as the parent super key
Is This Answer Correct ? | 11 Yes | 7 No |
Post New Answer View All Answers
Why we use trigger in sql server with example?
What does asynchronous call backs means?
What is conditional split?
What is meant by datasource?
How do I port a number to sql server?
How would we use distinct statement? What is its use?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What happens when converting big values to integers?
What is the difference between function and stored procedure in sql server?
How do I run a trace in sql server?
What does the on update no action do?
How much memory that we are using in Logshipping Concept?
Why we need sql server?
What methods do you follow to protect from sql injection attack?
What do you mean by subquery?