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 is a primary key? : Sql dba
What are different types of tables in sql?
What are operators available in sql?
What jobs use sql?
what is sql? : Sql dba
What is pl sql script?
What are the basic techniques of indexing?
Can two tables have same primary key?
how to delete an existing column in a table? : Sql dba
What is a parameter query?
What are sql queries used for?
What's the difference between a primary key and a clustered index?
what are date and time functions in mysql? : Sql dba
What are analytical functions in sql?
Why is pl sql used?