Классика баз данных - статьи
DEFINE SYNONYM identifier AS
asrt-name ::= name
trig-name ::= name
name ::= [ creator. ] idetifier
creator ::= identifier
user-name ::= identifier
field-name ::= identifier
var-name ::= identifier
cursor-name ::= identifier
pointer ::= identifier
save-point-name ::= identifier
host-location ::= identifier [ : identifier ]
integer ::= number
ddl-statement ::= create-table | expand-table | create-image | create-link | define-view | define-synonym | drop | comment
create-table ::= CREATE TABLE table-name ( field-defn-list )
field-defn-list ::= field-defn | field-defn-list, field-defn
field-defn ::= field-name ( type [ , NONULL ] )
type ::= CHAR ( integer ) [ VAR ] | INTEGER | SMALLINT | DECIMAL ( integer, [ integer ] ) | FLOAT
expand-table ::= EXPAND TABLE table-name ADD COLUMN field-defn
create-image ::= CREATE [ image-mod-list ] IMAGE image-name ON table-name ( ord-spec-list )
image-mod-list := image-mod | image-mod-list image-mod
image-mod ::= UNIQUE | CLUSTERING
create-link ::= CREATE [ CLUSTERING ] LINK link-name FROM table-name ( field-name-list ) TO table-name ( field-name-list ) [ ORDER BY ord-spec-list ]
define-view ::= DEFINE VIEW table-name [ ( filed-name-list ) ] AS query
define-synonym ::= DEFINE SYNONYM identifier AS table-name
drop ::= DROP system-entity name
comment ::= COMMENT ON system-entity name : quoted-string | COMMENT ON COLUMN table-name.field-name : quoted-string
system-entity ::= TABLE | VIEW | ASSERTION | TRIGGER | IMAGE | LINK
control-statement ::= asrt-statement | define-trigger | grant | revoke | begin-trans | end-trans | save | restore
asrt-statement ::= ASSERT asrt-name [ IMMEDIATE ] [ ON asrt-condition ] : boolean
asrt-condition ::= action-list | table-name [ var-name ]
action-list ::= action | action-list, action
action ::= INSERTION OF table-name [ var-name ] | DELETION OF table-name [ var-name ] | UPDATE OF table-name [ var-name ] [ ( filed-name-list ) ]
define-trigger ::= DEFINE TRIGGER trig-name ON trig-condition : ( statement-list )
