Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 325432 - use "drop table <tableName> cascade" to drop table
Summary: use "drop table <tableName> cascade" to drop table
Status: REOPENED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC All
: P2 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-09-16 06:16 EDT by zhao jianyong CLA
Modified: 2022-06-09 10:21 EDT (History)
1 user (show)

See Also:

Attachments
use "drop table <tableName> cascade" to drop table (1.01 KB, patch)
2010-09-16 06:38 EDT, zhao jianyong CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description zhao jianyong CLA 2010-09-16 06:16:18 EDT 
Build Identifier: 

For Symfoware all indices should be deleted before "drop table <tableName>".
While elements which are created by the old programme are dropped by the new
one. It may cause some indices would not be dropped before dropping table.

So I think "drop table <tableName> cascade" may be a better way to drop table
than "drop table <tableName>". 
Because with "cascade", even the indices are not be dropped before, the table
could be dropped prettily.

And "cascade" is specified in sql92, so most databases should support it.

Reproducible: Always
Comment 1 zhao jianyong CLA 2010-09-16 06:38:53 EDT 
Created attachment 179018 [details]
use "drop table <tableName> cascade" to drop table

Use "drop table <tableName> cascade" to drop table.
And "deletionStringFor" method seems no useful, so delete it.
Comment 2 Tom Ware CLA 2010-09-16 08:13:56 EDT 

*** This bug has been marked as a duplicate of bug 324341 ***
Comment 3 Tom Ware CLA 2010-09-23 13:11:22 EDT 
Reopening.  Functioanlity not implemented in previous bug.
Comment 4 Eclipse Webmaster CLA 2022-06-09 10:21:20 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink