Interested to Buy Any Domain ? << Click Here >> for more details...
What is ON DELETE CASCADE?
- 3 Answers
- 11301 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 |
i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk
HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)
Which type of cursor is used to execute the dml statement?
How many types of privileges are available in sql?
What is secondary key?
What is ttitle and btitle?
can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?
Explain ttitle and btitle.
What does sign mean sql?
what is the difference between group by and order by in sql? : Sql dba
What do you mean by field in sql?
Explain what is a column in a table?
-
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)
