beautypg.com

HP Integrity NonStop H-Series User Manual

Page 174

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

This manual is related to the following products: