Nonstop Database, HiRDB Version 9 Command Reference
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
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.