Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 325432

Summary: use "drop table <tableName> cascade" to drop table
Product: z_Archived Reporter: zhao jianyong <zjy.net>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: REOPENED --- QA Contact:
Severity: enhancement    
Priority: P2 CC: tom.ware
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: All   
Whiteboard:
Attachments:
Description Flags
use "drop table <tableName> cascade" to drop table none

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