How to write query to Delete the records in child table
and corresponding records in parent table
Answers were Sorted based on User's Feedback
Answer / vaishali
delete from child_table, parent_table where
child_table.parent_id=parent_table.parent_id
| Is This Answer Correct ? | 14 Yes | 26 No |
Do you know what are the ways available in sql server to execute sql statements?
What is sql collation?
Explain where clause?
What Is Rdbms?
How do I find the size of a sql server database?
What are the types of subquery?
What is indexing in sql server with example?
What is RMS migrations?
What you can do to delete a table without the delete trigger firing?
what's new in sql server 2016?
Define candidate key, alternate key, and composite key.
why would you call update statistics? : Sql server database administration
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)