HP NonStop G-Series User Manual

Page 165

Advertising
background image

Managing Tables

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

Advertising