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 the differences between public, private, protected, static, transient, final and volatile? : Sql dba
How to order siblings in oracle hierarchy queries?
How do I kill a query in postgresql?
Define commit, rollback and savepoint?
what are the 'mysql' command line options? : Sql dba
What is Materialized View? In What Scenario we Use Materialized View?
What is data control language (dcl)?
What is difference between sql and mysql?
How sql query is executed?
Does inner join remove duplicates?
What does the file extension accdb stand for?
What is procedure in pl sql?
what is a database transaction? : Sql dba
How do I restart sql?
Write the alter statement to enable all the triggers on the t.students table.