rebuild option in PSD?

[adtPSD]

I use to use TOAD and now seriously considering using PSD (yeah!) for our database work here.
There is an option under Tools...Rebuild Table in TOAD that will create a script, that basically creates a copy of the table, which I can modify for migration purposes.

 

[Marco Kalter]

If you just want to obtain the DDL that will recreate the table, there are several options:

1. Tools > Export User Objects

Here you can export the DDL of an arbitrary selection of objects.

2. Drag & Drop

Select the table in the Object Browser, drag & drop it into an editor (e.g. the Command Window's Editor), and select "DDL" from the popup menu.

3. Table Definition Editor

Select the table in the Object Browser or in a PL/SQL source, right-click on it, and select View from the popup menu. Press the "View SQL" button to see the DDL statements for the table.

If you also want to have the table data, you need to use the Export Tables tool (Tools > Export Tables, or right-click on the table and select "Export" from the popup menu). The Export Tables tool allows you to export the DDL and data in plain SQL format.

------------------
Marco Kalter
Allround Automations