Классика баз данных - статьи

       

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 )


Содержание  Назад  Вперед