background image
| 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