How to write query to Delete the records in child table
and corresponding records in parent table
Answer Posted / vaishali
delete from child_table, parent_table where
child_table.parent_id=parent_table.parent_id
Is This Answer Correct ? | 14 Yes | 26 No |
Post New Answer View All Answers
How do you start single user mode in clustered installations?
What is @@rowcount in sql?
Mention the different authentication modes in sql server.
why would you call update statistics? : Sql server database administration
What is a functions and types in sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
how many bits ip address consist of? : Sql server database administration
What is the difference between resultset and resultsetmetadata?
How to compare the top two records using sql?
plss anybody specify tha constrian management system in dbms
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is attribute relationships, why we need it? : sql server analysis services, ssas
When you use @@error and try-catch?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
Why Master database is required?