Re: cascade keyword

Cascade is like a tree.

For example:
You grant access to an user named USR1 and this user creates his own views, tables, etc.,
User USR1 grants access to an user named USR2 and this user also creates his own tables.

If you drop user USR1 with 'DROP USER USR1', only USR1 will be dropped. His tables etc. will still be available. But if you drop user USR1 with 'DROP USER USR1 CASCADE', USR will be dropped, his tables will be dropped AND ---- USR2 will be dropped with its tables!

Same with foreign keys. If you make it cascade and you delete a record, all the childs will be deleted too.

That's the meaning of cascade.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!