|
Contents - SQL expressions >>
Contents - SQL language reference
|
Contents - SQL expressions >>
Version 10.8 Derby Reference Manual
i
Contents
About this guide
..................................................................................................................
15
Purpose of this document
......................................................................................
15
Audience
................................................................................................................... 15
How this guide is organized
...................................................................................15
SQL language reference
.....................................................................................................
17
Capitalization and special characters
....................................................................
17
SQL identifiers
........................................................................................................ 17
Rules for SQL92 identifiers.................................................................................
18
SQL92Identifier....................................................................................................
18
column-Name.......................................................................................................
19
correlation-Name.................................................................................................
19
new-table-Name...................................................................................................
20
schemaName.......................................................................................................
20
Simple-column-Name..........................................................................................
20
synonym-Name....................................................................................................
20
table-Name..........................................................................................................
21
view-Name...........................................................................................................
21
index-Name..........................................................................................................
21
constraint-Name...................................................................................................
21
cursor-Name........................................................................................................
22
TriggerName........................................................................................................
22
AuthorizationIdentifier..........................................................................................
22
RoleName............................................................................................................
22
Statements
................................................................................................................
23
Interaction with the dependency system.............................................................
23
ALTER TABLE statement....................................................................................
24
CALL (PROCEDURE) statement........................................................................
28
CREATE statements...........................................................................................
29
DECLARE GLOBAL TEMPORARY TABLE statement.......................................
50
DELETE statement..............................................................................................
53
DROP statements................................................................................................
54
GRANT statement ..............................................................................................
57
INSERT statement...............................................................................................
60
LOCK TABLE statement.....................................................................................
62
RENAME statements...........................................................................................
63
REVOKE statement ...........................................................................................
.64
SELECT statement..............................................................................................
68
SET statements...................................................................................................
70
TRUNCATE TABLE statement............................................................................
73
UPDATE statement.............................................................................................
73
SQL clauses
.............................................................................................................
74
CONSTRAINT clause..........................................................................................
74
FOR UPDATE clause..........................................................................................
81
FROM clause.......................................................................................................
81
GROUP BY clause..............................................................................................
82
HAVING clause...................................................................................................
83
ORDER BY clause..............................................................................................
83
The result offset and fetch first clauses..............................................................
85