Interested to Buy Any Domain ? << Click Here >> for more details...
What is ON DELETE CASCADE?
- 3 Answers
- 11128 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 |
Explain UNION,MINUS,UNION ALL, INTERSECT?
What are expressions?
What are commit, rollback, and savepoint?
What is triggering circuit?
Whate is use of MOD function in pl/sql.
Can delete statement be rollbacked?
What are all types of user defined functions?
write a query to delete similar records in different tables with same structure
can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
what eliminate duplicate without using roenum and not
what is an extent ? : Sql dba
What does sql stand for?
-
Oracle (3259) - 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)
