Forums Register Login

DBVisualizer: drop and recreate table

+Pie Number of slices to send: Send
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?
+Pie Number of slices to send: Send
Dar,

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

Regards

Roger
+Pie Number of slices to send: Send
Hi Roger,

I'm using Oracle 10g
+Pie Number of slices to send: Send
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

+Pie Number of slices to send: Send
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


reply
reply
This thread has been viewed 2494 times.
Similar Threads
Using DbVisualizer & Other Tools for Database Table Navigation
What is in DBVisualizer for us Oracle users what other tools don't deliver?
DbVisualizer
DbVisualizer vs Squirrel SQL
DbVisualizer: Does it have any forum
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 08:45:58.