CREATE TABLE
(<_>
[, <_> | <> ]);
<_> - .
<_> = { _ | COMPUTED [ BY ]
(<>) | }
[ DEFAULT { | NULL | USER } ]
[NOT NULL] [<_>]
:
CREATE TABLE SAL_HIST
QUORTER INTEGER NOT NULL,
LAST_YEAR INTEGER,
THIS_YEAR INTEGER,
DELTA COMPUTED_BY (THIS_YEAR - LAST_YEAR),
PRIMARY KEY (QUORTER));
| QUORTER | LAST_YEAR | THIS_YEAR | DELTA |
| -20 | |||
:
;
.
:
TOVAR VARCHAR(20) NOT NULL PRIMARY KEY,
:
CREATE TABLE (
TOVAR VARCHAR(20) NOT NULL
PRIMARY KEY (TOVAR)
);
3.3.6. ()
:
CREATE TABLE VLADLIM (
KODVLAD INTEGER NOT NULL PRIMARY KEY,
NAZVVLAD VARCHAR(50) NOT NULL UNIQUE
);
:
CREATE TABLE VLADLIM (
KODVLAD INTEGER NOT NULL,
NAZVVLAD VARCHAR(50) NOT NULL,
PRIMARY KEY (KODVLAD),
UNIQUE ()NAZVVLAD)
);
.
:
[CONSTRAINT < >]
FOREIGN KEY (< >)
REFERENCES < >
[ < > ]
[ON DELETE { NO ACTION | CACADE | SET DEFAULT | SET NULL}]
[ON UPDATE { NO ACTION | CACADE | SET DEFAULT | SET NULL}]
:
CREATE TABLE P (
PK_FIELD INTEGER NOT NULL,
OTHER FIELD INTEGER,
PRIMARY KEY (PK_FIELD)
);
CREATE TABLE F (
PK_FIELD1 INTEGER NOT NULL,
PK_FIELD2 INTEGER NOT NULL,
SOME_FIELD INTEGER,
PRIMARY KEY (PK_FIELD1,PK_FIELD2),
FOREIGN KEY (PK_FIELD1) REFERENCES P
ON UPDATE CASCADE
);
:
CREATE TABLE PERSON _PARAMS (
ID_INTEGER NOT NULL PRIMARY KEY,
HEIGHT INTEGER NOT NULL,
WIEGHT INTEGER NOT NULL CHECK (HEIGHT > WIEGHT)
);
---------------------------------------------------------------------------------
CREATE TABLE RASHOD (
CONSTRAINT PO_DATE_RASH
CHECK (EXISTS (SELECT TOVAR FROM PRIHOD
WHERE PROHOD.TOVAR=RASHOD.TOVAR))
);
USD
CHECK (STOLBEZ CONTAINING USD)
USD
CHECK (STOLBEZ STARTING WITH USD)
ALTER TABLE :
ALTER TABLE < > ADD < >;
|
|
|
ALTER TABLE < > DROP < 1> [,< 2>
ALTER TABLE < > DROP < >
ALTER TABLE < > ADD [CONSTRAINT < >] < >;
:
DROP TABLE < >
:
. - .
- , .
:
, :
;
;
;
;
, :
, ,
, ;
:
CREATE TABLE SOTR (
ID_SOTR INTEGER NOT NULL,
OTDEL VARCHAR (10),
DOLGNOST CHAR (10),
FIO VARCHAR(25),
PRIMARY KEY (ID_SOTR));
CREATE INDEX DLJ ON SOTR (DOLGNOST);
:
DLJ INDEX ON SOTR (DOLGNOST)
RDB$PRIMARY18 UNIQUE INDEX ON SOTR (ID_SOTR)
. , .
:
ALTER INDEX < > DEACTIVATE;
ALTER INDEX < > ACTIVATE;
:
,
, , .
