Imprimer cette page

Télécharger le lexique SQL au format .zip

CREATE TABLE namejable

(name_col1 type_col [NOT NULL] [UNIQUE]

[PRIMARY KEY]...

name_col2 type_col2....

PRIMARY KEY (name_col_1, name_col_2, ...),

FOREIGN KEY (name_col,...) REFERENCES

name_table(name_col,... )

CHECK (expression)

CREATE TABLE namejable

(name_col...)

AS SELECT...;

ALTER TABLE namejable

ADD(name_col type_col [NOT NULL], ...)

DROP(name_col, ...)

MODIFY(name_col type_col [NOT NULL],...) ;

ALTER TABLE namejable

ADD CONSTRAINT

FOREIGN KEY (name_col,...)

REFERENCES namejable (name_col,...)

ON UPDATE CASCADE | SET NULL

N0 ACTION | SET DEFAULT

,ON DELETE CASCADE ....

CREATE [UNIQUE] INDEX namejndex

ON namejable (name_col [ASC | DESC], ...);

DROP INDEX namejndex [ON namejable]

[TABLE namejable ;

INSERT INTO namejable (name_col1. name_col2,...)

VALUES(valeur1, valeur2, ...);

UPDATE namejable [alias]

SET name_col ='...'

[WHERE condition];

UPDATE namejable [alias]

SET (name_col,...) = (SELECT ...) | * =

(SELECT ...)

[WHERE condition]

DELETE FROM namejable

[WHERE coédition];

SELECT [ALL|DISTlNCT] name_col,..

[INTO :var_host,...] (embedded sql)

FROM namejable [alias],...

[WHERE condition]

[CROUP BY ...]

[HAVING condition]

[UNION...]

[ORDER BY ...]

EXEC SQL DECLARE name_cursor CURSOR

FOR SELECT...

[FOR UPDATE 0F (name_col, ...)];

EXEC SQL BEGIN DECLARE SECTION;

varjiost;

EXEC SQL END DECLARE SECTION;

EXEC SQL OPEN name_cursor ;

EXEC SQL WHENEVER SQLERROR | QLWARNING

NOT FOUND GOTO ... 1 CONTINUE | STOP;

EXEC SQL FETCH name_cursor

{ INTO : varjiost, ... } ;

CLOSE name cursor;

COMMIT;

ROLLBACK;

GRANT SELECT j INSERT | UPDATE

| UPDATE(name_col) |DELETE

|REFERENCES|ALL

ON name_object

TO users,... |PUBLIC

[WITH GRANT OPTION];

REVOKE SELECT |...

ON name_object

FROM users,...

RESTRICT | CASCADE;

Arithmetic operators

+;-;*;/

Character operator

Comparison operators

= • 1= • <> ^ > ; >=

IN;NOT IN

ANY ; ALL

[NOT] BETWEEN x AND y

[NOT]EXISTS

Types de données

CHARACTER( ) OU CHAR( ),

CHARACTER VARYING ou VARCHAR( ),

NUMERIC(précision, échelle),

DECIMAL(précision, échelle),

INTEGER,

SMALLINT,

FLOAT, REAL, DOUBLE PRECISION,

DATE,

TIME,

Caractères génériques

(0 à n caractères) et_ (1 caractère)

Fonctions de dates

sysdate(), day(date), month(date), year(date)