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