Nonstop Database, HiRDB Version 9 Command Reference

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

9.1.4 Generation of a definition SQL

A definition SQL is generated and output to a file on the basis of the export file definition information. The following table lists the definition SQL statements that can be generated:

Type Index definition Comment definition Definition SQL statements to be generated
Base table Specified Specified CREATE TABLE
CREATE INDEX
COMMENT
Not specified CREATE TABLE
CREATE INDEX
Not specified Specified CREATE TABLE
COMMENT
Not specified CREATE TABLE
View table -- Specified CREATE VIEW
COMMENT
Not specified CREATE VIEW
Trigger -- -- CREATE TRIGGER
Stored procedure -- -- CREATE PROCEDURE

Legend: --: Not applicable