What is ON DELETE CASCADE?
- 3 Answers
- 10277 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tulsi
The main use of ON DELETE CASCADE is to delete the child
records automatically from a table when the related records
from master table is deleted.
Assign the ON DELETE CASCADE clause while creating the
foreign key
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / vilas
Yes,its true and won't display any error while deleting the
master table.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ansupriya
If child record exists user cannot delete parent record.
Using on delete cascade on foreign constraint user can delete parent record .
Same time automatically it will delete the child record.
| Is This Answer Correct ? | 0 Yes | 1 No |
what are the advantages of using stored procedures? : Sql dba
What is faster join or subquery?
explain commit and rollback in mysql : sql dba
What is trigger in pl sql?
How to display Row Number with Records in Oracle SQL Plus?
What is oracle sql developer?
What are the indexing methods?
What is pl/sql language case sensitive?
How many sql commands are there?
What are the different schemas objects that can be created using pl/sql?
Is sql a microsoft product?
How much does sqlite cost?
-
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)
