Subject | drop table XX cascade |
---|---|
Author | karthick srini |
Post date | 2004-09-27T08:44:28Z |
Dear Memebers,
Is the functionlaity CASCADE is supported in drop
table.
i.e. drop table <table_name> cascade
I believe cascade is not an ANSI standard. But still
some DB supports CASCADE in drop table. since our
application needs CASCADE in drop , If there is any
way to achieve CASCADE functionlity in drop table
please do let me know about it,
Note : CASCADE in drop table will remove associated
child table constraints. (FK constraint)
S.Karthick
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
Is the functionlaity CASCADE is supported in drop
table.
i.e. drop table <table_name> cascade
I believe cascade is not an ANSI standard. But still
some DB supports CASCADE in drop table. since our
application needs CASCADE in drop , If there is any
way to achieve CASCADE functionlity in drop table
please do let me know about it,
Note : CASCADE in drop table will remove associated
child table constraints. (FK constraint)
S.Karthick
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail