What is Cascade and Restrict when we use DROP table in SQL SERVER ?
When we are using Drop table in SQL the syntax is simple.
Drop table table_name(CASCADE / RESTRICT)
We use cascade to drop table although it have some dependencies just like triggers,stroeprocrdure,primarykey,foreignkey it will delete first.
But if we use restrict a error message is shown on using of DROP if the table have relation Trigger,storeprocedure.
Posted at 9:41 PM | Labels: Interview questions |
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment