Owner manual

Managing Tables12-40
Figure 12-29. Recreate Tables Window.
Recreating Tables
The Recreate Table function allows you to create an SQL script that will
create the table, partitions of the table, and indexes on the table as it exists
on the NonStop machine at the time you execute this function. You can
save the script for later use by clicking Save Command.
To recreate a table
1. Select the table to be recreated from the Catalogs and Tables pane
2. Commands, columns names and statistics for the table selected will be
displayed
3. Click on SaveCommand to save the SQL script, or click on Close to
cancel.