Pages

Men

rh

6/03/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