Приложение E
ТАБЛИЦЫ ИСПОЛЬЗУЕМЫЕ В SQL

ТАБЛИЦА 1: ПРОДАВЦЫ

ТАБЛИЦА 2: ЗАКАЗЧИКИ

ТАБЛИЦА 3: ПОРЯДКИ

Команда SELECT

SELECT * | { [ DISTINCT | ALL] < value expression >.,..}
FROM { < table name > [ < alias > ] }.,..
[ WHERE <predicate>]
[ GROUP BY { <column name> | <integer> }.,..]
[ HAVING <predicate>]
[ ORDERBY { <column name> | <integer> }.,..]


[ { UNION [ALL]


SELECT * | { [DISTINCT | ALL] < value expression >.,..}
FROM { <table name> [<alias>]} .,..
[ WHERE < predicate >
[ GROUP BY { <columnname> | <integer> }.,..]
[ HAVING <predicate >]
[ ORDER BY { <columnname> | <integer> }.,..] } ] ...;

Команды UPDATE INSERT DELETE

UPDATE


UPDATE <tablename>
SET { | }.,. .< column name>=<value expresslon>
[ WHERE <predlcate>
| WHERE CURRENT OF <cursor name>
(*только для вложения*) ];



INSERT

INSERT INTO < table name> [(<column name> ., . ]
{ VALUES ( <value expression> .,.. ) }
| <query>;


DELETE


DELETE FROM <table name>
[ WHERE <predicate>
| WHERE CURRENT OF <cursor name>
(*только для вложения*) ];

Команда CREATE TABLE

CREATE TABLE <table name>
( { <column name> <data type> I<size>]
[<colcnstrnt> ...]} .,.. );
[<tabconstrnt>] .,.. );