aspose file tools*
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
Similar Threads
DbVisualizer
DbVisualizer: Does it have any forum
What is in DBVisualizer for us Oracle users what other tools don't deliver?
Using DbVisualizer & Other Tools for Database Table Navigation
DbVisualizer vs Squirrel SQL