Interested to Buy Any Domain ? << Click Here >> for more details...
What is ON DELETE CASCADE?
- 3 Answers
- 11233 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 types of join and explain each? : Sql dba
What is RAC in oracle?
How many types of triggers are there in pl sql?
How do you modify a trigger?
write a query to delete similar records in different tables with same structure
what is the difference between clustered and non clustered index in sql? : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
Can we insert data in view?
What is foreign key in sql with example?
What is the usage of sql functions?
Sql technical questions
Describe the Index, Types of index, At what situation we have used? Which one s better than others?
-
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)
