Dar Var
,
Ranch Hand
Mar 18, 2009 04:39:41
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
Mar 18, 2009 04:44:54
Dar,
DbVisualizer Personal can generate the DDL for some databases. What DB are you using?
Regards
Roger
Dar Var
,
Ranch Hand
Mar 18, 2009 04:46:48
Hi Roger,
I'm using Oracle 10g
Roger Bjärevall
,
DbVisualizer Support
Mar 18, 2009 06:11:59
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
Mar 18, 2009 06:13:30
Great stuff. Sounds like exactly what I need.
Proudly marching to the beat of a different kettle of fish... while reading this tiny ad
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com