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
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
Explain the types of joins in sql?
What is difference between nchar and nvarchar?
How do I tune a sql query?
Where is all the data on the internet stored?
Define a temp table?
what are aggregate and scalar functions? : Sql dba
How can use stored procedures in sql?
What are the commands used in sql?
What is function and procedure?
Is sql a backend language?
What is the difference between sql and isql*plus?
What is nvarchar max in sql?
How to read/write files from pl/sql?
What is procedure explain with example?