A
- ABS function, Numeric Functions
- ACOS function, Numeric Functions
- ACTION_ID function, System Functions
- ADD COLUMN, Table Manipulation
- add column identity generator, Table Manipulation
- ADD CONSTRAINT, Table Manipulation
- ADD DOMAIN CONSTRAINT, Domain Creation and Manipulation
- ADMINISTRABLE_ROLE_AUTHORIZATIONS, SQL Standard Views
- aggregate function, Aggregate Functions
- ALL and ANY predicates, Predicates
- ALTER COLUMN, Table Manipulation
- alter column identity generator, Table Manipulation
- alter column nullability, Table Manipulation
- ALTER DOMAIN, Domain Creation and Manipulation
- ALTER INDEX, Other Schema Object Creation
- ALTER routine, Routine Creation
- ALTER SEQUENCE, Sequence Creation
- ALTER SESSION, Session and Transaction Control Statements
- ALTER TABLE, Table Manipulation
- ALTER USER ... SET INITIAL SCHEMA, Statements for
Authorization and Access Control
- ALTER USER ... SET LOCAL, Statements for
Authorization and Access Control
- ALTER USER ... SET PASSWORD, Statements for
Authorization and Access Control
- ALTER view, View Creation and Manipulation
- APPLICABLE_ROLES, SQL Standard Views
- ASCII function, String and Binary String Functions
- ASIN function, Numeric Functions
- ASSERTIONS, SQL Standard Views
- ATAN2 function, Numeric Functions
- ATAN function, Numeric Functions
- AUTHORIZATION IDENTIFIER, Authorizations and Access Control
- AUTHORIZATIONS, SQL Standard Views
B
- BACKUP DATABASE, System Operations
- BETWEEN predicate, Predicates
- binary literal, Literals
- BINARY types, Binary String Types
- BIT_LENGTH function, String and Binary String Functions
- BITAND function, Numeric Functions
- BITANDNOT function, Numeric Functions
- bit literal, Literals
- BITNOT function, Numeric Functions
- 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
- CASEWHEN function, General Functions
- CASE WHEN in routines, Conditional Statements
- CAST, Value Expression
- CEIL function, Numeric Functions
- CHANGE_AUTHORIZATION, Built-In Roles and Users
- CHAR_LENGTH, String and Binary String Functions
- CHARACTER_LENGTH, String and Binary String Functions
- CHARACTER_SETS, SQL Standard Views
- character literal, Literals
- CHARACTER types, Character String Types
- character value function, Value Expression
- CHAR function, String and Binary String Functions
- CHECK_CONSTRAINT_ROUTINE_USAGE, SQL Standard Views
- CHECK_CONSTRAINTS, SQL Standard Views
- CHECK constraint, Table Creation
- CHECKPOINT, System Operations
- COALESCE expression, Value Expression
- COALESCE function, General Functions
- COLLATE, Other Syntax Elements
- COLLATIONS, SQL Standard Views
- COLUMN_COLUMN_USAGE, SQL Standard Views
- COLUMN_DOMAIN_USAGE, SQL Standard Views
- COLUMN_PRIVILEGES, SQL Standard Views
- COLUMN_UDT_USAGE, SQL Standard Views
- column definition, Table Creation
- column name list, Table Primary
- column reference, References, etc.
- COLUMNS, SQL Standard Views
- COMMENT, Commenting Objects
- COMMIT, Session and Transaction Control Statements
- comparison predicate, Predicates
- CONCAT function, String and Binary String Functions
- CONSTRAINT, Other Syntax Elements
- CONSTRAINT_COLUMN_USAGE, SQL Standard Views
- CONSTRAINT_TABLE_USAGE, SQL Standard Views
- CONSTRAINT (table constraint), Table Creation
- CONSTRAINT name and characteristics, Table Creation
- 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
- 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 function, System Functions
- CURDATE function, Functions to Report the Current Datetime
- CURRENT_CATALOG function, System Functions
- CURRENT_DATE function, Functions to Report the Current Datetime
- CURRENT_ROLE function, System Functions
- CURRENT_SCHEMA function, System Functions
- CURRENT_TIME function, Functions to Report the Current Datetime
- CURRENT_TIMESTAMP function, Functions to Report the Current Datetime
- CURRENT_USER function, System Functions
- CURRENT VALUE FOR, Value Expression
- CURTIME function, Functions to Report the Current Datetime
D
- DATA_TYPE_PRIVILEGES, SQL Standard Views
- DATABASE_ISOLATION_LEVEL function, System Functions
- DATABASE_NAME function, System Functions
- DATABASE_TIMEZONE function, Functions to Report the Time Zone.
- DATABASE_VERSION function, System Functions
- DATABASE function, System Functions
- DATE_ADD function, Functions for Datetime Arithmetic
- DATE_SUB function, Functions for Datetime Arithmetic
- DATEADD function, Functions for Datetime Arithmetic
- DATEDIFF function, Functions for Datetime Arithmetic
- 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, Functions to Extract an Element of a Datetime
- DAYOFMONTH function, Functions to Extract an Element of a Datetime
- DAYOFWEEK function, Functions to Extract an Element of a Datetime
- DAYOFYEAR function, Functions to Extract an Element of a Datetime
- DAYS function datetime, Functions to Extract an Element of a Datetime
- DBA ROLE, Built-In Roles and Users
- DECLARE CURSOR, Cursor Declaration
- DECLARE HANDLER, Handlers
- DECLARE variable, Variables
- DECODE function, General Functions
- DEFAULT clause, Table Creation
- DEGREES function, Numeric Functions
- DELETE FROM, Delete Statement
- derived table, Table Primary
- DETERMINISTIC characteristic, Routine Characteristics
- DIAGNOSTICS function, System Functions
- DIFFERENCE function, String and Binary String Functions
- DISCONNECT, Session and Transaction Control Statements
- DOMAIN_CONSTRAINTS, SQL Standard Views
- DOMAINS, SQL Standard Views
- 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 Manipulation
- drop column idenitty generator, Table Manipulation
- DROP CONSTRAINT, Table Manipulation
- DROP DEFAULT (table), Table 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
- 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
- IDENTITY function, System Functions
- IF EXISTS, Common Elements and Statements
- IFNULL function, General Functions
- IF STATEMENT, Conditional Statements
- INFORMATION_SCHEMA_CATALOG_NAME, SQL Standard Views
- 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
- IS_AUTOCOMMIT function, System Functions
- IS_READONLY_DATABASE_FILES function, System Functions
- IS_READONLY_DATABASE function, System Functions
- IS_READONLY_SESSION function, System Functions
- IS DISTINCT predicate, Predicates
- ISNULL function, General Functions
- IS NULL predicate, Predicates
- ISOLATION_LEVEL function, System Functions
L
- LANGUAGE, Routine Characteristics
- LATERAL, Table Primary
- 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
- LOAD_FILE function, General Functions
- LOB_ID function, System Functions
- LOCALTIME function, Functions to Report the Current Datetime
- LOCALTIMESTAMP function, Functions to Report the Current Datetime
- LOCATE function, String and Binary String Functions
- LOCK TABLE, Session and Transaction Control Statements
- LOG10 function, Numeric Functions
- LOG function, Numeric Functions
- LOOP in routines, Iterated Statements
- LPAD function, String and Binary String 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, Functions to Report the Current Datetime
- 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
- NVL2 function, General Functions
- NVL function, General Functions
R
- RADIANS function, Numeric Functions
- RAND function, Numeric Functions
- RAWTOHEX function, String and Binary String Functions
- REFERENTIAL_CONSTRAINTS, SQL Standard Views
- REGEXP_MATCHES function, String and Binary String Functions
- REGEXP_SUBSTRING_ARRAY function, String and Binary String Functions
- REGEXP_SUBSTRING function, String and Binary String Functions
- RELEASE SAVEPOINT, Session and Transaction Control Statements
- RENAME, Renaming Objects
- REPEAT ... UNTIL loop in routines, Iterated Statements
- REPEAT function, String and Binary String Functions
- REPLACE function, String and Binary String Functions
- RESIGNAL STATEMENT, Raising Exceptions
- 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
- ROLE_AUTHORIZATION_DESCRIPTORS, SQL Standard Views
- ROLE_COLUMN_GRANTS, SQL Standard Views
- ROLE_ROUTINE_GRANTS, SQL Standard Views
- ROLE_TABLE_GRANTS, SQL Standard Views
- ROLE_UDT_GRANTS, SQL Standard Views
- ROLE_USAGE_GRANTS, SQL Standard Views
- ROLLBACK, Session and Transaction Control Statements
- ROLLBACK TO SAVEPOINT, Session and Transaction Control Statements
- ROUND function datetime, Functions for Datetime Arithmetic
- ROUND number function, Numeric Functions
- ROUTINE_COLUMN_USAGE, SQL Standard Views
- ROUTINE_JAR_USAGE, SQL Standard Views
- ROUTINE_PRIVILEGES, SQL Standard Views
- ROUTINE_ROUTINE_USAGE, SQL Standard Views
- ROUTINE_SEQUENCE_USAGE, SQL Standard Views
- ROUTINE_TABLE_USAGE, SQL Standard Views
- routine body, Routine Definition
- routine invocation, Other Syntax Elements
- ROUTINES, SQL Standard Views
- ROW_NUMBER function, System Functions
- ROWNUM function, System Functions
- row value expression, Value Expression
- RPAD function, String and Binary String Functions
- RTRIM function, String and Binary String Functions
S
- SAVEPOINT, Session and Transaction Control Statements
- SAVEPOINT LEVEL, Routine Characteristics
- schema routine, Routine Creation
- SCHEMATA, SQL Standard Views
- SCRIPT, System Operations
- search condition, Other Syntax Elements
- SECOND function, Functions to Extract an Element of a Datetime
- SECONDS_SINCE_MIDNIGHT function, Functions to Extract an Element of a Datetime
- SELECT, Select Statement
- SELECT : SINGLE ROW, Select Statement : Single Row
- SEQUENCE_ARRAY function, Array Functions
- SEQUENCES, SQL Standard Views
- SESSION_ID function, System Functions
- SESSION_ISOLATION_LEVEL function, System Functions
- SESSION_TIMEZONE function, Functions to Report the Time Zone.
- 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 AUTHENTICATION FUNCTION, Authentication Settings
- SET DATABASE COLLATION, Database Settings
- SET DATABASE DEFAULT INITIAL SCHEMA, Statements for
Authorization and Access Control
- SET DATABASE DEFAULT ISOLATION LEVEL, Database Settings
- SET DATABASE DEFAULT RESULT MEMORY ROWS, Database Settings
- SET DATABASE DEFAULT TABLE TYPE, Database Settings
- SET DATABASE EVENT LOG LEVEL, Database Settings
- SET DATABASE GC, Database Settings
- SET DATABASE PASSWORD CHECK FUNCTION, Authentication Settings
- SET DATABASE SQL AVG SCALE, SQL Conformance Settings
- SET DATABASE SQL CONCAT NULLS, SQL Conformance Settings
- SET DATABASE SQL CONVERT TRUNCATE, SQL Conformance Settings
- SET DATABASE SQL DOUBLE NAN, SQL Conformance Settings
- SET DATABASE SQL NAMES, SQL Conformance Settings
- SET DATABASE SQL NULLS FIRST, SQL Conformance Settings
- SET DATABASE SQL REFERENCES, SQL Conformance Settings
- SET DATABASE SQL REGULAR NAMES, SQL Conformance Settings
- SET DATABASE SQL SIZE, SQL Conformance Settings
- SET DATABASE SQL SYNTAX DB2, SQL Conformance Settings
- SET DATABASE SQL SYNTAX MSS, SQL Conformance Settings
- SET DATABASE SQL SYNTAX MYS, SQL Conformance Settings
- SET DATABASE SQL SYNTAX ORA, SQL Conformance Settings
- SET DATABASE SQL SYNTAX PGS, SQL Conformance Settings
- SET DATABASE SQL TDC DELETE, SQL Conformance Settings
- SET DATABASE SQL TRANSLATE TTI TYPES, SQL Conformance Settings
- SET DATABASE SQL TYPES, SQL Conformance Settings
- SET DATABASE SQL UNIQUE NULLS, SQL Conformance Settings
- SET DATABASE TEXT TABLE DEFAULTS, Database Settings
- SET DATABASE TRANSACTION CONTROL, Database Settings
- SET DATABASE TRANSACTION ROLLBACK ON CONFLICT, Database Settings
- SET DATABASE UNIQUE NAME, Database Settings
- SET DATA TYPE, Table Manipulation
- SET DEFAULT, Table Manipulation
- SET DOMAIN DEFAULT, Domain Creation and Manipulation
- SET FILES BACKUP INCREMENT, Cache, Persistence and Files Settings
- SET FILES CACHE ROWS, Cache, Persistence and Files Settings
- SET FILES CACHE SIZE, Cache, Persistence and Files Settings
- SET FILES DEFRAG, Cache, Persistence and Files Settings
- SET FILES LOB SCALE, Cache, Persistence and Files Settings
- SET FILES LOG, Cache, Persistence and Files Settings
- SET FILES LOG SIZE, Cache, Persistence and Files Settings
- SET FILES NIO, Cache, Persistence and Files Settings
- SET FILES NIO SIZE, Cache, Persistence and Files Settings
- SET FILES SCALE, Cache, Persistence and Files Settings
- SET FILES SCRIPT FORMAT, Cache, Persistence and Files Settings
- SET FILES WRITE DELAY, Cache, Persistence and Files Settings
- 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, SQL Conformance Settings
- 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 CLUSTERED, Table Manipulation
- SET TABLE read-write property, Table Manipulation
- SET TABLE SOURCE, Table Manipulation
- SET TABLE SOURCE HEADER, Table Manipulation
- SET TABLE SOURCE on-off, Table Manipulation
- SET TABLE TYPE, Table Manipulation, Cache, Persistence and Files Settings
- SET TIME ZONE, Session and Transaction Control Statements
- SET TRANSACTION, Session and Transaction Control Statements
- SHUTDOWN, System Operations
- SIGNAL STATEMENT, Raising Exceptions
- SIGN function, Numeric Functions
- SIN function, Numeric Functions
- SORT_ARRAY function, Array Functions
- sort specification list, Ordering
- SOUNDEX function, String and Binary String Functions
- SPACE function, String and Binary String Functions
- SPECIFIC, Common Elements and Statements
- SPECIFIC NAME, Routine Characteristics
- SQL_FEATURES, SQL Standard Views
- SQL_IMPLEMENTATION_INFO, SQL Standard Views
- SQL_PACKAGES, SQL Standard Views
- SQL_PARTS, SQL Standard Views
- SQL_SIZING, SQL Standard Views
- SQL_SIZING_PROFILES, SQL Standard Views
- 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
- SYSDATE function, Functions to Report the Current Datetime
- SYSTEM_BESTROWIDENTIFIER, HyperSQL Custom Views
- SYSTEM_CACHEINFO, HyperSQL Custom Views
- SYSTEM_COLUMN_SEQUENCE_USAGE, HyperSQL Custom Views
- SYSTEM_COLUMNS, HyperSQL Custom Views
- SYSTEM_COMMENTS, HyperSQL Custom Views
- SYSTEM_CONNECTION_PROPERTIES, HyperSQL Custom Views
- SYSTEM_CROSSREFERENCE, HyperSQL Custom Views
- SYSTEM_INDEXINFO, HyperSQL Custom Views
- SYSTEM_PRIMARYKEYS, HyperSQL Custom Views
- SYSTEM_PROCEDURECOLUMNS, HyperSQL Custom Views
- SYSTEM_PROCEDURES, HyperSQL Custom Views
- SYSTEM_PROPERTIES, HyperSQL Custom Views
- SYSTEM_SCHEMAS, HyperSQL Custom Views
- SYSTEM_SEQUENCES, HyperSQL Custom Views
- SYSTEM_SESSIONINFO, HyperSQL Custom Views
- SYSTEM_SESSIONS, HyperSQL Custom Views
- SYSTEM_TABLES, HyperSQL Custom Views
- SYSTEM_TABLETYPES, HyperSQL Custom Views
- SYSTEM_TEXTTABLES, HyperSQL Custom Views
- SYSTEM_TYPEINFO, HyperSQL Custom Views
- SYSTEM_UDTS, HyperSQL Custom Views
- SYSTEM_USER function, System Functions
- SYSTEM_USERS, HyperSQL Custom Views
- SYSTEM_VERSIONCOLUMNS, HyperSQL Custom Views
- SYSTIMESTAMP function, Functions to Report the Current Datetime
- SYS USER, Built-In Roles and Users
T
- TABLE, Table Primary
- TABLE_CONSTRAINTS, SQL Standard Views
- TABLE_PRIVILEGES, SQL Standard Views
- TABLES, SQL Standard Views
- TAN function, Numeric Functions
- TIMESTAMPADD function, Functions for Datetime Arithmetic
- TIMESTAMPDIFF function, Functions for Datetime Arithmetic
- TIMESTAMP function, Functions to Convert or Format a Datetime
- Time Zone, Datetime types
- TIMEZONE function, Functions to Report the Time Zone.
- TO_CHAR function, Functions to Convert or Format a Datetime
- TO_DATE function, Functions to Convert or Format a Datetime
- TO_NUMBER function, Numeric Functions
- TO_TIMESTAMP function, Functions to Convert or Format a Datetime
- TODAY function, Functions to Report the Current Datetime
- TRANSACTION_CONTROL function, System Functions
- TRANSACTION_ID function, System Functions
- TRANSACTION_SIZE function, System Functions
- transaction characteristics, Session and Transaction Control Statements
- TRANSLATIONS, SQL Standard Views
- TRIGGER_COLUMN_USAGE, SQL Standard Views
- TRIGGER_ROUTINE_USAGE, SQL Standard Views
- TRIGGER_SEQUENCE_USAGE, SQL Standard Views
- TRIGGER_TABLE_USAGE, SQL Standard Views
- TRIGGERED_UPDATE_COLUMNS, SQL Standard Views
- TRIGGERED SQL STATEMENT, Trigger Creation
- TRIGGER EXECUTION ORDER, Trigger Creation
- TRIGGERS, SQL Standard Views
- TRIM_ARRAY function, Array Functions
- TRIM function, String and Binary String Functions
- TRUNCATE function, Numeric Functions
- TRUNCATE SCHEMA, Truncate Statement
- TRUNCATE TABLE, Truncate Statement
- TRUNC function datetime, Functions for Datetime Arithmetic
- TRUNC function numeric, Numeric Functions
U
- UCASE function, String and Binary String Functions
- unicode escape elements, Literals
- UNION JOIN, Joined Table
- UNIQUE constraint, Table Creation
- UNIQUE predicate, Predicates
- UNIX_TIMESTAMP function, Functions to Extract an Element of a Datetime
- UNNEST, Table Primary
- UPDATE, Update Statement
- UPPER function, String and Binary String Functions
- USAGE_PRIVILEGES, SQL Standard Views
- USER_DEFINED_TYPES, SQL Standard Views
- USER function, System Functions
- UUID function, General Functions
$Revision: 4864 $
