Statements | Description | Syntax |
---|---|---|
CREATE | It is used to create tables or relations. | CREATE <table-name> <list-of-column-name> |
RANGE | It allows to declare a range variable and restricts to assume the values that are rows from the specified table. Row variables are called Range variables in QUEL. | RANGE OF <variable-name> IS <relation-name> |
INDEX | It is used to specify the name of the secondary index to be built and the columns in the table on which the index is to be created. | INDEX ON <table-name> IS <index-name> (column-name [, column-name, ...]) |
DESTROY | It is used to eliminate a table, index or view. | DESTROY name [, name, ...] |
MODIFY | It is used to modify the structure of a table. The storage structure supported by INGRES are B-tree, hash, ISAM and heap. The storage structure will be modified from the current one to the one specified in the statement. | MODIFY <table-name> TO <storage-structure> ON <column-name> |