Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

14.5 Creating a definition SQL from an existing index

Executor: HiRDB administrator or a user with DBA privilege

The pddefrev command can be used to create a definition SQL from an existing index.

This command is useful for creating a new index by using an existing index's definition. A definition SQL created with the pddefrev command is used as the input information to the database definition utility (pddef command).

Reference note
Plug-in indexes are not processed by the pddefrev command (a definition SQL cannot be created).