Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DBVisualizer: drop and recreate table

 
Dar Var
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dar,

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

Regards

Roger
 
Dar Var
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Roger,

I'm using Oracle 10g
 
Roger Bjärevall
DbVisualizer Support
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Great stuff. Sounds like exactly what I need.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic