User Id :    Password :      New Member   Forgot Password  
Topic: What is Cascade and Restrict when we use DROP table in SQL SERVER
Sachin Jain
29 Oct 2010 at 11:28 PM
What is Cascade and Restrict when we use DROP table in SQL SERVER.
Re: What is Cascade and Restrict when we use DROP table in SQL SERVER
Gaurav
01 Nov 2010 at 12:09 AM

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.

Total Replies: 1
 
Featured Text Ad

Featured Ad