User guide

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 HP 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.