Please visit DEMANDDRAFT.SHOP for quality of products...

Ad

Search This Blog

Sunday, June 3, 2012

Use of Cascade and Restrict while Drop Table in SQL Server

When we use the Cascade to Drop table although, it has some dependencies just like Trigger, Stored procedures, Primary key, Forignkey , it will delete first.

But if we use Restrict, an error message is shown on using of Drop if the table have some relation triggers, stored procedures.

Syntax:
DROP  Tablename(Cascade/Restrict)

No comments:

Post a Comment