A
- ABS function, Numeric Functions
- ACL, Network Access Control
- ACOS function, Numeric Functions
- ADD COLUMN, Table Creation and Manipulation
- ADD CONSTRAINT, Table Creation and Manipulation
- ADD DOMAIN CONSTRAINT, Domain Creation and Manipulation
- aggregate function, Other Syntax Elements
- ALL and ANY predicates, Predicates
- ALTER COLUMN, Table Creation and Manipulation
- alter column nullability, Table Creation and Manipulation
- ALTER DOMAIN, Domain Creation and Manipulation
- alter identity column, Table Creation and Manipulation
- ALTER routine, Routine Creation
- ALTER SEQUENCE, Sequence Creation
- ALTER TABLE, Table Creation and Manipulation
- ALTER USER ... SET INITIAL SCHEMA, Statements for
Authorization and Access Control
- ALTER USER ... SET PASSWORD, Statements for
Authorization and Access Control
- ALTER view, View Creation and Manipulation
- Ant, Building with Apache Ant
- ASCII function, String and Binary String Functions
- ASIN function, Numeric Functions
- ATAN2 function, Numeric Functions
- ATAN function, Numeric Functions
- AUTHORIZATION IDENTIFIER, Authorizations and Access Control
B
- backup, Backing Up Database Catalogs
- BACKUP DATABASE, Statements
- BETWEEN predicate, Predicates
- binary literal, Literals
- BINARY types, Binary String Types
- BIT_LENGTH function, String and Binary String Functions
- BITAND function, Numeric Functions
- bit literal, Literals
- BITOR function, Numeric Functions
- BIT types, Bit String Types
- BITXOR function, Numeric Functions
- boolean literal, Literals
- BOOLEAN types, Boolean Type
- boolean value expression, Value Expression
C
- CARDINALITY function, Array Functions
- CASCADE or RESTRICT, Common Elements and Statements
- case expression, Value Expression
- CASE WHEN in routines, Conditional Statements
- CAST, Value Expression
- CEIL function, Numeric Functions
- CHANGE_AUTHORIZATION, Built-In Roles and Users
- CHARACTER_LENGTH, String and Binary String Functions
- character literal, Literals
- CHARACTER types, Character String Types
- character value function, Value Expression
- CHECK constraint, Table Creation and Manipulation
- CHECKPOINT, Statements
- COALESCE expression, Value Expression
- COALESCE function, General Functions
- COLLATE, Other Syntax Elements
- column definition, Table Creation and Manipulation
- column reference, References, etc.
- COMMENT, Commenting Objects
- COMMIT, Session and Transaction Control Statements
- comparison predicate, Predicates
- CONCAT function, String and Binary String Functions
- CONSTRAINT, Other Syntax Elements
- CONSTRAINT (table constraint), Table Creation and Manipulation
- CONSTRAINT name and characteristics, Table Creation and Manipulation
- contextually typed value specification, References, etc.
- CONVERT function, General Functions
- COS function, Numeric Functions
- COT function, Numeric Functions
- CREATE_SCHEMA ROLE, Built-In Roles and Users
- CREATE AGGREGATE FUNCTION, Definition of Aggregate Functions
- CREATE ASSERTION, Other Schema Object Creation
- CREATE CAST, Other Schema Object Creation
- CREATE CHARACTER SET, Other Schema Object Creation
- CREATE COLLATION, Other Schema Object Creation
- CREATE DOMAIN, Domain Creation and Manipulation
- CREATE FUNCTION, Routine Definition
- CREATE INDEX, Other Schema Object Creation
- CREATE PROCEDURE, Routine Definition
- CREATE ROLE, Statements for
Authorization and Access Control
- CREATE SCHEMA, Schema Creation
- CREATE SEQUENCE, Sequence Creation
- CREATE TABLE, Table Creation and Manipulation
- CREATE TRANSLATION, Other Schema Object Creation
- CREATE TRIGGER, Trigger Creation, Trigger Creation
- CREATE TYPE, Other Schema Object Creation
- CREATE USER, Statements for
Authorization and Access Control
- CREATE VIEW, View Creation and Manipulation
- CROSS JOIN, Joined Table
- CRYPT_KEY, Statements
- CRYPT_KEY function, System Functions
- CURDATE function, Date Time and Interval Functions
- CURRENT_CATALOG function, System Functions
- CURRENT_DATE function, Date Time and Interval Functions
- CURRENT_ROLE function, System Functions
- CURRENT_SCHEMA function, System Functions
- CURRENT_TIME function, Date Time and Interval Functions
- CURRENT_TIMESTAMP function, Date Time and Interval Functions
- CURRENT_USER function, System Functions
- CURTIME function, Date Time and Interval Functions
D
- DATABASE_ISOLATION_LEVEL function, System Functions
- DATABASE_TIMEZONE function, Date Time and Interval Functions
- DATABASE_VERSION function, System Functions
- DATABASE function, System Functions
- DATEADD function, Date Time and Interval Functions
- DATEDIFF function, Date Time and Interval Functions
- datetime and interval literal, Literals
- Datetime Operations, Datetime types
- DATETIME types, Datetime types
- datetime value expression, Value Expression
- datetime value function, Value Expression
- DAYNAME function, Date Time and Interval Functions
- DAYOFMONTH function, Date Time and Interval Functions
- DAYOFWEEK function, Date Time and Interval Functions
- DAYOFYEAR function, Date Time and Interval Functions
- DBA ROLE, Built-In Roles and Users
- DECODE function, General Functions
- DEFAULT clause, Table Creation and Manipulation
- DEGREES function, Numeric Functions
- DELETE FROM, Delete Statement
- DETERMINISTIC characteristic, Routine Characteristics
- DIFFERENCE function, String and Binary String Functions
- DISCONNECT, Session and Transaction Control Statements
- DROP ASSERTION, Other Schema Object Creation
- DROP CAST, Other Schema Object Creation
- DROP CHARACTER SET, Other Schema Object Creation
- DROP COLLATION, Other Schema Object Creation
- DROP COLUMN, Table Creation and Manipulation
- DROP CONSTRAINT, Table Creation and Manipulation
- DROP DEFAULT (table), Table Creation and Manipulation
- DROP DOMAIN, Domain Creation and Manipulation
- DROP DOMAIN CONSTRAINT, Domain Creation and Manipulation
- DROP DOMAIN DEFAULT, Domain Creation and Manipulation
- DROP INDEX, Other Schema Object Creation
- DROP ROLE, Statements for
Authorization and Access Control
- DROP routine, Routine Creation
- DROP SCHEMA, Schema Creation
- DROP SEQUENCE, Sequence Creation
- DROP TABLE, Table Creation and Manipulation
- DROP TRANSLATION, Other Schema Object Creation
- DROP TRIGGER, Trigger Creation, Trigger Creation
- DROP USER, Statements for
Authorization and Access Control
- DROP VIEW, View Creation and Manipulation
- DYNAMIC RESULT SETS, Routine Characteristics
I
- identifier chain, References, etc.
- identifier definition, Common Elements and Statements, Overview
- IDENTITY function, System Functions
- IF EXISTS, Common Elements and Statements
- IFNULL function, General Functions
- IF STATEMENT, Conditional Statements
- init script, Running Hsqldb as a System Daemon
- IN predicate, Predicates
- INSERT function, String and Binary String Functions
- INSERT INTO, Insert Statement
- interval absolute value function, Value Expression
- interval term, Value Expression
- INTERVAL types, Interval Types
- ISAUTOCOMMIT function, System Functions
- IS DISTINCT predicate, Predicates
- IS NULL predicate, Predicates
- ISOLATION_LEVEL function, System Functions
- ISREADONLYDATABASEFILES function, System Functions
- ISREADONLYDATABASE function, System Functions
- ISREADONLYSESSION function, System Functions
L
- LANGUAGE, Routine Characteristics
- LCASE function, String and Binary String Functions
- LEAST function, General Functions
- LEFT function, String and Binary String Functions
- LENGTH function, String and Binary String Functions
- LIKE predicate, Predicates
- LN function, Numeric Functions
- LOCALTIME function, Date Time and Interval Functions
- LOCALTIMESTAMP function, Date Time and Interval Functions
- LOCATE function, String and Binary String Functions
- LOCK TABLE, Session and Transaction Control Statements
- LOG10 function, Numeric Functions
- LOG function, Numeric Functions
- LTRIM function, String and Binary String Functions
N
- name resolution, Naming
- naming in joined table, Naming
- naming in select list, Naming
- NATURAL JOIN, Joined Table
- NEXT VALUE FOR, Value Expression
- NOW function, Date Time and Interval Functions
- NULLIF expression, Value Expression
- NULLIF function, General Functions
- NULL INPUT, Routine Characteristics
- numeric literal, Literals
- NUMERIC types, Numeric Types
- numeric value expression, Value Expression
- numeric value function, Value Expression
- NVL function, General Functions
R
- RADIANS function, Numeric Functions
- RAND function, Numeric Functions
- RAWTOHEX function, String and Binary String Functions
- REGEXP_MATCHES function, String and Binary String Functions
- RELEASE SAVEPOINT, Session and Transaction Control Statements
- RENAME, Renaming Objects
- REPEAT function, String and Binary String Functions
- REPLACE function, String and Binary String Functions
- RETURN, Return Statement
- RETURNS, Routine Definition
- REVERSE function, String and Binary String Functions
- REVOKE, Statements for
Authorization and Access Control
- REVOKE ROLE, Statements for
Authorization and Access Control
- RIGHT function, String and Binary String Functions
- ROLLBACK, Session and Transaction Control Statements
- ROLLBACK TO SAVEPOINT, Session and Transaction Control Statements
- ROUND function, Numeric Functions
- routine body, Routine Definition
- routine invocation, Other Syntax Elements
- row value expression, Value Expression
- RTRIM function, String and Binary String Functions
S
- SA USER, Built-In Roles and Users
- SAVEPOINT, Session and Transaction Control Statements
- SAVEPOINT LEVEL, Routine Characteristics
- schema routine, Routine Creation
- SCRIPT, Statements
- search condition, Other Syntax Elements
- SECOND function, Date Time and Interval Functions
- SECONDS_SINCE_MIDNIGHT function, Date Time and Interval Functions
- security, Security Considerations, TLS Encryption, Network Access Control
- SELECT : SINGLE ROW, Select Statement : Single Row
- SESSION_ISOLATION_LEVEL function, System Functions
- SESSION_TIMEZONE function, Date Time and Interval Functions
- SESSION_USER function, System Functions
- SET AUTOCOMMIT, Session and Transaction Control Statements
- SET CATALOG, Session and Transaction Control Statements
- set clause in UPDATE and MERGE statements, Update Statement
- SET CONSTRAINTS, Session and Transaction Control Statements
- SET DATABASE COLLATION, Statements
- SET DATABASE DEFAULT INITIAL SCHEMA, Statements for
Authorization and Access Control
- SET DATABASE DEFAULT RESULT MEMORY ROWS, Statements
- SET DATABASE DEFAULT TABLE TYPE, Statements
- SET DATABASE EVENT LOG LEVEL, Statements
- SET DATABASE GC, Statements
- SET DATABASE SQL NAMES, Statements
- SET DATABASE SQL REFERENCES, Statements
- SET DATABASE SQL SIZE, Statements
- SET DATABASE TRANSACTION CONTROL, Session and Transaction Control Statements, Statements
- SET DATABASE UNIQUE NAME*, Statements
- SET DATA TYPE, Table Creation and Manipulation
- SET DEFAULT, Table Creation and Manipulation
- SET DOMAIN DEFAULT, Domain Creation and Manipulation
- SET FILES BACKUP INCREMENT, Statements
- SET FILES CACHE ROWS, Statements
- SET FILES CACHE SIZE, Statements
- SET FILES DEFRAG, Statements
- SET FILES LOB SCALE, Statements
- SET FILES LOG, Statements
- SET FILES LOG SIZE, Statements
- SET FILES NIO, Statements
- SET FILES SCALE, Statements
- SET FILES WRITE DELAY, Statements
- set function specification, Value Expression
- SET IGNORECASE, Session and Transaction Control Statements
- SET INITIAL SCHEMA*, Statements for
Authorization and Access Control
- SET MAXROWS, Session and Transaction Control Statements
- SET OPERATIONS, Set Operations
- SET PASSWORD, Statements for
Authorization and Access Control
- SET PATH, Session and Transaction Control Statements
- SET REFERENTIAL INTEGRITY, Statements
- SET ROLE, Session and Transaction Control Statements
- SET SCHEMA, Session and Transaction Control Statements
- SET SESSION AUTHORIZATION, Session and Transaction Control Statements
- SET SESSION CHARACTERISTICS, Session and Transaction Control Statements
- SET SESSION RESULT MEMORY ROWS, Session and Transaction Control Statements
- SET TABLE read-write property, Table Creation and Manipulation
- SET TABLE SOURCE, Table Creation and Manipulation
- SET TABLE SOURCE HEADER, Table Creation and Manipulation
- SET TABLE SOURCE on-off, Table Creation and Manipulation
- SET TIME ZONE, Session and Transaction Control Statements
- SET TRANSACTION, Session and Transaction Control Statements
- SHUTDOWN, Statements
- SIGN function, Numeric Functions
- SIN function, Numeric Functions
- sort specification list, Other Syntax Elements
- SOUNDEX function, String and Binary String Functions
- SPACE function, String and Binary String Functions
- SPECIFIC, Common Elements and Statements
- SPECIFIC NAME, Routine Characteristics
- SQL DATA access characteristic, Routine Characteristics
- SQL parameter reference, References, etc.
- SQL procedure statement, SQL Procedure Statement
- SQL routine body, Routine Definition
- SQRT function, Numeric Functions
- START TRANSACTION, Session and Transaction Control Statements
- string value expression, Value Expression
- SUBSTR function, String and Binary String Functions
- SUBSTRING function, String and Binary String Functions
- SYSTEM_USER function, System Functions
T
- TAN function, Numeric Functions
- TIMESTAMPADD function, Date Time and Interval Functions
- TIMESTAMPDIFF function, Date Time and Interval Functions
- Time Zone, Datetime types
- TIMEZONE function, Date Time and Interval Functions
- TO_CHAR function, Date Time and Interval Functions
- TRANSACTION_CONTROL function, System Functions
- transaction characteristics, Session and Transaction Control Statements
- TRIGGERED SQL STATEMENT, Trigger Creation
- TRIGGER EXECUTION ORDER, Trigger Creation
- TRIM_ARRAY function, Array Functions
- TRIM function, String and Binary String Functions
- TRUNCATE function, Numeric Functions
- TRUNCATE TABLE, Truncate Statement
$Revision: 3601 $