Interested to Buy Any Domain ? << Click Here >> for more details...
What is ON DELETE CASCADE?
- 3 Answers
- 11166 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 |
How to run pl/sql statements in sql*plus?
what are the different index configurations a table can have? : Sql dba
How do you respond to dementia behavior?
What does plv msg allows you to do?
What is a pdo connection?
What is null in pl/sql?
Can we use two order by clause in query?
What is the purpose of using pl/sql?
overloading of stored procedure is possible in oracle?
How many columns should be in an index?
What is the size of partition table?
How well can multiple sessions access the same data simultaneously ?
-
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)
