Nonstop Database, HiRDB Version 9 System Operation Guide

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

13.20 Creating a definition SQL from an existing table

Executor: HiRDB administrator or DBA privilege holder

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

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

Reference note
A table for which an abstract data type is defined cannot be processed by the pddefrev command (a definition SQL cannot be created from it).