wood burning stoves*
The moose likes JDBC and the fly likes DBVisualizer: drop and recreate table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DBVisualizer: drop and recreate table" Watch "DBVisualizer: drop and recreate table" New topic
Author

DBVisualizer: drop and recreate table

Dar Var
Ranch Hand

Joined: Oct 12, 2004
Posts: 74
Hi,

On occastion for test purposes I need to drop tables and re-create them.

Is there any way in DBVisualizer to select an existing table and output the SQL required to re-create table?

Also, what if the table has indexes? Can DBVisualizer provide the queries to recreate those indexes?
Roger Bjärevall
DbVisualizer Support
Greenhorn

Joined: Feb 19, 2009
Posts: 25
Dar,

DbVisualizer Personal can generate the DDL for some databases. What DB are you using?

Regards

Roger
Dar Var
Ranch Hand

Joined: Oct 12, 2004
Posts: 74
Hi Roger,

I'm using Oracle 10g
Roger Bjärevall
DbVisualizer Support
Greenhorn

Joined: Feb 19, 2009
Posts: 25
Dar,

Oracle is one of the supported databases. In the current version it doesn't generate
DDL for indexes. PRIMARY KEYS and UNIQUE constraints are however supported.

The next feature version has the new "Export Table" feature which also generates
DDL for indexes.

Regards

Roger

Dar Var
Ranch Hand

Joined: Oct 12, 2004
Posts: 74
Great stuff. Sounds like exactly what I need.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DBVisualizer: drop and recreate table