CREATE TABLE . |
:
CREATE TABLE (_1 [()]
[NOT NULL] [_1] [, _2 [()]
[NOT NULL] [_2] [,...]] [, CONSTRAINT [,...]])
CREATE TABLE:
.
_1, _2 , . .
.
( ).
_1, _2 CONSTRAINT, . CONSTRAINT.
CONSTRAINT, . CONSTRAINT.
CREATE INDEX . |
:
CREATE [ UNIQUE ] INDEX
ON ( [ASC|DESC][, [ASC|DESC],...])
[WITH { PRIMARY | DISALLOW NULL | IGNORE NULL }]
CREATE INDEX:
.
, .
, . ( ) . ( ) . DESC; .
.
. |
CONSTRAINT , .
CONSTRAINT ALTER TABLE CREATE TABLE . CONSTRAINT: ( ), ( ).
:
CONSTRAINT {PRIMARY KEY | UNIQUE | NOT NULL |
REFERENCES [(_1, _2)]}
CONSTRAINT:
, .
, , .
_1, _2 , , _1, _2. , .
. |
CONSTRAINT , .
|
|
CONSTRAINT ALTER TABLE CREATE TABLE . CONSTRAINT: ( ), ( ).
:
CONSTRAINT
{PRIMARY KEY (_1[, _2 [,...]]) |
UNIQUE (_1[, _2 [,...]]) |
NOT NULL (_1[, _2 [,...]]) |
FOREIGN KEY (_1[, _2 [,...]])
REFERENCES [(_1 [, _2 [,...]])]}
CONSTRAINT:
, .
_1, _2 , .
_1, _2 , .
_1, _2 , Null.
_1, _2 , , .
, , .
_1, _2 , , _1, _2. , .