How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 31674 Views
- Semantic Space, I also Faced
- E-Mail Answers
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 |
Explain various On-Delete options in a DB table. Which is the default option?
0 Answers Akamai Technologies,
What is the use of commit?
what's the difference between a primary key and a unique key? : Sql server database administration
What are the different types of lock modes in sql server 2000?
What is change tracking in sql server?
What is the bookmark lookup and rid lookup?
How to create view in stored procedure sql server?
Explain for xml explicit mode?
How does normalization work?
What is sql server programming?
What is store procedure?
What is a transaction and why is it important?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
