Answer Posted / 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 |
Post New Answer View All Answers
what are date and time intervals? : Sql dba
Does user triggers have entry for trigger with compilation errors?
What is the purpose of my sql?
What does fetching a cursor do?
What are all different types of collation sensitivity?
How do I make my sql query run faster?
Is not equal in sql?
what are the performance and scalability characteristics of mysql? : Sql dba
What is lexical units in pl sql?
Can I join the same table twice?
How to display the records between two range in Oracle SQL Plus?
Is sql better than access?
What are the parameter modes supported by pl/sql?
What are some predefined exceptions in pl/sql?
What is foreign key in sql with example?
