Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / naresh
If you specify this option, later when you delete a row in
the parent table, the database server also deletes any rows
associated with that row (foreign keys) in a child table.
The principal advantage to the cascading-deletes feature is
that it allows you to reduce the quantity of SQL statements
you need to perform delete actions.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What do you understand by sql server agent?
Do you know what is user defined datatypes and when you should go for them?
What are unicode character string data types in ms sql server?
What is a user-defined function in the sql server and what is its advantage?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
How can you fetch alternate records from a table?
What is a rownum?
What does indexation mean?
Can group by and orderby be used together?
How can we check the sql server version?
Explain primary key in sql server?
Give main differences between "Truncate" and "Delete".
What are the aggregate and scalar functions?
What is the difference between system objects and user objects?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
