<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>General Index</title>
<link href="../docbook.css" type="text/css" rel="stylesheet">
<meta content="DocBook XSL Stylesheets V1.77.1" name="generator">
<meta name="keywords" content="Hsqldb, HyperSQL, Database, JDBC, Java">
<link rel="home" href="index.html" title="HyperSQL User Guide">
<link rel="up" href="index.html" title="HyperSQL User Guide">
<link rel="prev" href="sql-ind.html" title="SQL Index">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<div class="navheader">
<table summary="Navigation header" width="100%">
<tr>
<td align="left" width="30%"><a accesskey="p" href="sql-ind.html"><img src="../images/db/prev.png" alt="Prev"></a> </td><td align="center" width="40%" style="font-weight:bold;">General Index</td><td align="right" width="30%"> </td>
</tr>
<tr>
<td valign="top" align="left" width="30%">SQL Index </td><td align="center" width="40%"><a accesskey="h" href="index.html"><img src="../images/db/home.png" alt="Home"></a></td><td valign="top" align="right" width="30%"> </td>
</tr>
</table>
</div>
<HR>
<div class="index">
<div class="titlepage">
<div>
<div>
<h1 class="title">
<a name="book-ind"></a>General Index</h1>
</div>
</div>
</div>
<div class="index">
<div class="indexdiv">
<h3>Symbols</h3>
<dl>
<dt>_SYSTEM ROLE, <a class="indexterm" href="accesscontrol-chapt.html#acc_built_in_roles_users">Built-In Roles and Users</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>A</h3>
<dl>
<dt>ABS function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>ACL, <a class="indexterm" href="listeners-chapt.html#lsc_acl">Network Access Control</a>
</dt>
<dt>ACOS function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>ACTION_ID function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>ADD COLUMN, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>add column identity generator, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>ADD CONSTRAINT, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>ADD DOMAIN CONSTRAINT, <a class="indexterm" href="databaseobjects-chapt.html#dbc_domain_creation">Domain Creation and Manipulation</a>
</dt>
<dt>ADMINISTRABLE_ROLE_AUTHORIZATIONS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>aggregate function, <a class="indexterm" href="dataaccess-chapt.html#N12538">Aggregate Functions</a>
</dt>
<dt>ALL and ANY predicates, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>ALTER COLUMN, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>alter column identity generator, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>alter column nullability, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>ALTER DOMAIN, <a class="indexterm" href="databaseobjects-chapt.html#dbc_domain_creation">Domain Creation and Manipulation</a>
</dt>
<dt>ALTER INDEX, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>ALTER routine, <a class="indexterm" href="databaseobjects-chapt.html#dbc_routine_creation">Routine Creation</a>
</dt>
<dt>ALTER SEQUENCE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_sequence_creation">Sequence Creation</a>
</dt>
<dt>ALTER SESSION, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>ALTER TABLE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>ALTER USER ... SET INITIAL SCHEMA, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>ALTER USER ... SET LOCAL, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>ALTER USER ... SET PASSWORD, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>ALTER view, <a class="indexterm" href="databaseobjects-chapt.html#dbc_view_creation">View Creation and Manipulation</a>
</dt>
<dt>Ant, <a class="indexterm" href="building-app.html#building-ant-sect">Building with Apache Ant</a>
</dt>
<dt>APPLICABLE_ROLES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ASCII function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>ASIN function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>ASSERTIONS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ATAN2 function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>ATAN function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>AUTHORIZATION IDENTIFIER, <a class="indexterm" href="accesscontrol-chapt.html#acc_auth_and_access_ctrl">Authorizations and Access Control</a>
</dt>
<dt>AUTHORIZATIONS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>B</h3>
<dl>
<dt>backup, <a class="indexterm" href="management-chapt.html#mtc_backup">Backing Up Database Catalogs</a>
</dt>
<dt>BACKUP DATABASE, <a class="indexterm" href="management-chapt.html#mtc_system_operations">System Operations</a>
</dt>
<dt>BETWEEN predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>binary literal, <a class="indexterm" href="dataaccess-chapt.html#dac_literals">Literals</a>
</dt>
<dt>BINARY types, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_binary_types">Binary String Types</a>
</dt>
<dt>BIT_LENGTH function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>BITAND function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>BITANDNOT function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>bit literal, <a class="indexterm" href="dataaccess-chapt.html#dac_literals">Literals</a>
</dt>
<dt>BITNOT function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>BITOR function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>BIT types, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_bit_types">Bit String Types</a>
</dt>
<dt>BITXOR function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>boolean literal, <a class="indexterm" href="dataaccess-chapt.html#dac_literals">Literals</a>
</dt>
<dt>BOOLEAN types, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_boolean_type">Boolean Type</a>
</dt>
<dt>boolean value expression, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>C</h3>
<dl>
<dt>CARDINALITY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_array_functions">Array Functions</a>
</dt>
<dt>CASCADE or RESTRICT, <a class="indexterm" href="databaseobjects-chapt.html#dbc_common_elements">Common Elements and Statements</a>
</dt>
<dt>case expression, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>CASEWHEN function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>CASE WHEN in routines, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_conditional">Conditional Statements</a>
</dt>
<dt>CAST, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>CEIL function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>CHANGE_AUTHORIZATION, <a class="indexterm" href="accesscontrol-chapt.html#acc_built_in_roles_users">Built-In Roles and Users</a>
</dt>
<dt>CHAR_LENGTH, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>CHARACTER_LENGTH, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>CHARACTER_SETS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>character literal, <a class="indexterm" href="dataaccess-chapt.html#dac_literals">Literals</a>
</dt>
<dt>CHARACTER types, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_char_types">Character String Types</a>
</dt>
<dt>character value function, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>CHAR function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>CHECK_CONSTRAINT_ROUTINE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>CHECK_CONSTRAINTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>CHECK constraint, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>CHECKPOINT, <a class="indexterm" href="management-chapt.html#mtc_system_operations">System Operations</a>
</dt>
<dt>COALESCE expression, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>COALESCE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>COLLATE, <a class="indexterm" href="dataaccess-chapt.html#dac_other_syntax_elements">Other Syntax Elements</a>
</dt>
<dt>COLLATIONS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>COLUMN_COLUMN_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>COLUMN_DOMAIN_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>COLUMN_PRIVILEGES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>COLUMN_UDT_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>column definition, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>column name list, <a class="indexterm" href="dataaccess-chapt.html#dac_table_primary">Table Primary</a>
</dt>
<dt>column reference, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_references">References, etc.</a>
</dt>
<dt>COLUMNS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>COMMENT, <a class="indexterm" href="databaseobjects-chapt.html#dbc_commenting">Commenting Objects</a>
</dt>
<dt>COMMIT, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>comparison predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>CONCAT function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>CONSTRAINT, <a class="indexterm" href="dataaccess-chapt.html#dac_other_syntax_elements">Other Syntax Elements</a>
</dt>
<dt>CONSTRAINT_COLUMN_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>CONSTRAINT_TABLE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>CONSTRAINT (table constraint), <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>CONSTRAINT name and characteristics, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>contextually typed value specification, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_references">References, etc.</a>
</dt>
<dt>CONVERT function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>COS function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>COT function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>CREATE_SCHEMA ROLE, <a class="indexterm" href="accesscontrol-chapt.html#acc_built_in_roles_users">Built-In Roles and Users</a>
</dt>
<dt>CREATE AGGREGATE FUNCTION, <a class="indexterm" href="sqlroutines-chapt.html#src_aggregate_function_definition">Definition of Aggregate Functions</a>
</dt>
<dt>CREATE ASSERTION, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>CREATE CAST, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>CREATE CHARACTER SET, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>CREATE COLLATION, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>CREATE DOMAIN, <a class="indexterm" href="databaseobjects-chapt.html#dbc_domain_creation">Domain Creation and Manipulation</a>
</dt>
<dt>CREATE FUNCTION, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_definition">Routine Definition</a>
</dt>
<dt>CREATE INDEX, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>CREATE PROCEDURE, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_definition">Routine Definition</a>
</dt>
<dt>CREATE ROLE, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>CREATE SCHEMA, <a class="indexterm" href="databaseobjects-chapt.html#dbc_schema_creation">Schema Creation</a>
</dt>
<dt>CREATE SEQUENCE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_sequence_creation">Sequence Creation</a>
</dt>
<dt>CREATE TABLE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>CREATE TRANSLATION, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>CREATE TRIGGER, <a class="indexterm" href="databaseobjects-chapt.html#dbc_trigger_creation">Trigger Creation</a>, <a class="indexterm" href="triggers-chapt.html#trc_trigger_creation">Trigger Creation</a>
</dt>
<dt>CREATE TYPE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>CREATE USER, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>CREATE VIEW, <a class="indexterm" href="databaseobjects-chapt.html#dbc_view_creation">View Creation and Manipulation</a>
</dt>
<dt>CROSS JOIN, <a class="indexterm" href="dataaccess-chapt.html#dac_joined_table">Joined Table</a>
</dt>
<dt>CRYPT_KEY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>CURDATE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>CURRENT_CATALOG function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>CURRENT_DATE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>CURRENT_ROLE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>CURRENT_SCHEMA function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>CURRENT_TIME function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>CURRENT_TIMESTAMP function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>CURRENT_USER function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>CURRENT VALUE FOR, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>CURTIME function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>D</h3>
<dl>
<dt>DATA_TYPE_PRIVILEGES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>DATABASE_ISOLATION_LEVEL function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>DATABASE_NAME function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>DATABASE_TIMEZONE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_timezone_functions">Functions to Report the Time Zone.</a>
</dt>
<dt>DATABASE_VERSION function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>DATABASE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>DATE_ADD function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_arithmetic">Functions for Datetime Arithmetic</a>
</dt>
<dt>DATE_SUB function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_arithmetic">Functions for Datetime Arithmetic</a>
</dt>
<dt>DATEADD function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_arithmetic">Functions for Datetime Arithmetic</a>
</dt>
<dt>DATEDIFF function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_arithmetic">Functions for Datetime Arithmetic</a>
</dt>
<dt>datetime and interval literal, <a class="indexterm" href="dataaccess-chapt.html#dac_literals">Literals</a>
</dt>
<dt>Datetime Operations, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_datetime_types">Datetime types</a>
</dt>
<dt>DATETIME types, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_datetime_types">Datetime types</a>
</dt>
<dt>datetime value expression, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>datetime value function, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>DAYNAME function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>DAYOFMONTH function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>DAYOFWEEK function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>DAYOFYEAR function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>DAYS function datetime, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>DBA ROLE, <a class="indexterm" href="accesscontrol-chapt.html#acc_built_in_roles_users">Built-In Roles and Users</a>
</dt>
<dt>DECLARE CURSOR, <a class="indexterm" href="dataaccess-chapt.html#dac_declare_cursor">Cursor Declaration</a>
</dt>
<dt>DECLARE HANDLER, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_handlers">Handlers</a>
</dt>
<dt>DECLARE variable, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_vars">Variables</a>
</dt>
<dt>DECODE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>DEFAULT clause, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>DEGREES function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>DELETE FROM, <a class="indexterm" href="dataaccess-chapt.html#dac_delete_statement">Delete Statement</a>
</dt>
<dt>derived table, <a class="indexterm" href="dataaccess-chapt.html#dac_table_primary">Table Primary</a>
</dt>
<dt>DETERMINISTIC characteristic, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_characteristics">Routine Characteristics</a>
</dt>
<dt>DIAGNOSTICS function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>DIFFERENCE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>DISCONNECT, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>DOMAIN_CONSTRAINTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>DOMAINS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>DROP ASSERTION, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>DROP CAST, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>DROP CHARACTER SET, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>DROP COLLATION, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>DROP COLUMN, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>drop column idenitty generator, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>DROP CONSTRAINT, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>DROP DEFAULT (table), <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>DROP DOMAIN, <a class="indexterm" href="databaseobjects-chapt.html#dbc_domain_creation">Domain Creation and Manipulation</a>
</dt>
<dt>DROP DOMAIN CONSTRAINT, <a class="indexterm" href="databaseobjects-chapt.html#dbc_domain_creation">Domain Creation and Manipulation</a>
</dt>
<dt>DROP DOMAIN DEFAULT, <a class="indexterm" href="databaseobjects-chapt.html#dbc_domain_creation">Domain Creation and Manipulation</a>
</dt>
<dt>DROP INDEX, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>DROP ROLE, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>DROP routine, <a class="indexterm" href="databaseobjects-chapt.html#dbc_routine_creation">Routine Creation</a>
</dt>
<dt>DROP SCHEMA, <a class="indexterm" href="databaseobjects-chapt.html#dbc_schema_creation">Schema Creation</a>
</dt>
<dt>DROP SEQUENCE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_sequence_creation">Sequence Creation</a>
</dt>
<dt>DROP TABLE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>DROP TRANSLATION, <a class="indexterm" href="databaseobjects-chapt.html#dbc_other_object_creation">Other Schema Object Creation</a>
</dt>
<dt>DROP TRIGGER, <a class="indexterm" href="databaseobjects-chapt.html#dbc_trigger_creation">Trigger Creation</a>, <a class="indexterm" href="triggers-chapt.html#trc_trigger_creation">Trigger Creation</a>
</dt>
<dt>DROP USER, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>DROP VIEW, <a class="indexterm" href="databaseobjects-chapt.html#dbc_view_creation">View Creation and Manipulation</a>
</dt>
<dt>DYNAMIC RESULT SETS, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_characteristics">Routine Characteristics</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>E</h3>
<dl>
<dt>ELEMENT_TYPES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ENABLED_ROLES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>EXISTS predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>EXP function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>expression, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>external authentication, <a class="indexterm" href="management-chapt.html#mtc_authentication_control">Authentication Control</a>
</dt>
<dt>EXTERNAL NAME, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_definition">Routine Definition</a>
</dt>
<dt>EXTRACT function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>F</h3>
<dl>
<dt>FLOOR function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>FOREIGN KEY constraint, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>FOR loop in routines, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_for_statement">Iterated FOR Statement</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>G</h3>
<dl>
<dt>generated column specification, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>GET DIAGNOSTICS, <a class="indexterm" href="dataaccess-chapt.html#dac_diagnostics_state">Diagnostics and State</a>
</dt>
<dt>Gradle, <a class="indexterm" href="building-app.html#gradle-invoke--sect">Building with Gradle</a>
</dt>
<dt>GRANTED BY, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>GRANT privilege, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>GRANT role, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>GREATEST function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>GROUPING OPERATIONS, <a class="indexterm" href="dataaccess-chapt.html#dac_grouping_operations">Grouping Operations</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>H</h3>
<dl>
<dt>HEXTORAW function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>HOUR function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>I</h3>
<dl>
<dt>identifier chain, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_references">References, etc.</a>
</dt>
<dt>identifier definition, <a class="indexterm" href="databaseobjects-chapt.html#dbc_common_elements">Common Elements and Statements</a>
</dt>
<dt>IDENTITY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>IF EXISTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_common_elements">Common Elements and Statements</a>
</dt>
<dt>IFNULL function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>IF STATEMENT, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_conditional">Conditional Statements</a>
</dt>
<dt>INFORMATION_SCHEMA_CATALOG_NAME, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>init script, <a class="indexterm" href="unix-chapt.html#uxc_daemon">Running Hsqldb as a System Daemon</a>
</dt>
<dt>IN predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>INSERT function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>INSERT INTO, <a class="indexterm" href="dataaccess-chapt.html#dac_insert_statement">Insert Statement</a>
</dt>
<dt>interval absolute value function, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>interval term, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>INTERVAL types, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_interval_typs">Interval Types</a>
</dt>
<dt>IS_AUTOCOMMIT function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>IS_READONLY_DATABASE_FILES function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>IS_READONLY_DATABASE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>IS_READONLY_SESSION function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>IS DISTINCT predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>ISNULL function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>IS NULL predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>ISOLATION_LEVEL function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>J</h3>
<dl>
<dt>JOIN USING, <a class="indexterm" href="dataaccess-chapt.html#dac_joined_table">Joined Table</a>
</dt>
<dt>JOIN with condition, <a class="indexterm" href="dataaccess-chapt.html#dac_joined_table">Joined Table</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>K</h3>
<dl>
<dt>KEY_COLUMN_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>L</h3>
<dl>
<dt>LANGUAGE, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_characteristics">Routine Characteristics</a>
</dt>
<dt>LATERAL, <a class="indexterm" href="dataaccess-chapt.html#dac_table_primary">Table Primary</a>
</dt>
<dt>LCASE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>LEAST function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>LEFT function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>LENGTH function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>LIKE predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>LN function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>LOAD_FILE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>LOB_ID function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>LOCALTIME function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>LOCALTIMESTAMP function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>LOCATE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>LOCK TABLE, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>LOG10 function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>LOG function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>LOOP in routines, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_iterated_statements">Iterated Statements</a>
</dt>
<dt>LPAD function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>LTRIM function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>M</h3>
<dl>
<dt>MATCH predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>MAX_CARDINALITY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_array_functions">Array Functions</a>
</dt>
<dt>memory use, <a class="indexterm" href="deployment-chapt.html#dec_mem_disk_use">Memory and Disk Use</a>
</dt>
<dt>MERGE INTO, <a class="indexterm" href="dataaccess-chapt.html#dac_merge_statement">Merge Statement</a>
</dt>
<dt>MINUTE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>MOD function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>MONTH function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>MONTHNAME function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>N</h3>
<dl>
<dt>name resolution, <a class="indexterm" href="dataaccess-chapt.html#dac_naming">Naming</a>
</dt>
<dt>naming in joined table, <a class="indexterm" href="dataaccess-chapt.html#dac_naming">Naming</a>
</dt>
<dt>naming in select list, <a class="indexterm" href="dataaccess-chapt.html#dac_naming">Naming</a>
</dt>
<dt>NATURAL JOIN, <a class="indexterm" href="dataaccess-chapt.html#dac_joined_table">Joined Table</a>
</dt>
<dt>NEXT VALUE FOR, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>NOW function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>NULLIF function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>NULL INPUT, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_characteristics">Routine Characteristics</a>
</dt>
<dt>numeric literal, <a class="indexterm" href="dataaccess-chapt.html#dac_literals">Literals</a>
</dt>
<dt>NUMERIC types, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_numeric_types">Numeric Types</a>
</dt>
<dt>numeric value expression, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>numeric value function, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>NVL2 function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
<dt>NVL function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>O</h3>
<dl>
<dt>OCTET_LENGTH function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>OTHER type, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_java_objects">Storage and Handling of Java Objects</a>
</dt>
<dt>OUTER JOIN, <a class="indexterm" href="dataaccess-chapt.html#dac_joined_table">Joined Table</a>
</dt>
<dt>OVERLAPS predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>OVERLAY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>P</h3>
<dl>
<dt>PARAMETERS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>password complexity, <a class="indexterm" href="management-chapt.html#mtc_authentication_control">Authentication Control</a>
</dt>
<dt>PATH, <a class="indexterm" href="dataaccess-chapt.html#dac_other_syntax_elements">Other Syntax Elements</a>
</dt>
<dt>PI function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>POSITION_ARRAY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_array_functions">Array Functions</a>
</dt>
<dt>POSITION function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>POWER function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>PRIMARY KEY constraint, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>PUBLIC ROLE, <a class="indexterm" href="accesscontrol-chapt.html#acc_built_in_roles_users">Built-In Roles and Users</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>Q</h3>
<dl>
<dt>QUARTER function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>R</h3>
<dl>
<dt>RADIANS function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>RAND function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>RAWTOHEX function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>REFERENTIAL_CONSTRAINTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>REGEXP_MATCHES function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>REGEXP_SUBSTRING_ARRAY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>REGEXP_SUBSTRING function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>RELEASE SAVEPOINT, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>RENAME, <a class="indexterm" href="databaseobjects-chapt.html#dbc_renaming">Renaming Objects</a>
</dt>
<dt>REPEAT ... UNTIL loop in routines, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_iterated_statements">Iterated Statements</a>
</dt>
<dt>REPEAT function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>REPLACE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>RESIGNAL STATEMENT, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_exceptions">Raising Exceptions</a>
</dt>
<dt>RETURN, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_return_statement">Return Statement</a>
</dt>
<dt>RETURNS, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_definition">Routine Definition</a>
</dt>
<dt>REVERSE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>REVOKE, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>REVOKE ROLE, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>RIGHT function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>ROLE_AUTHORIZATION_DESCRIPTORS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROLE_COLUMN_GRANTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROLE_ROUTINE_GRANTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROLE_TABLE_GRANTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROLE_UDT_GRANTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROLE_USAGE_GRANTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROLLBACK, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>ROLLBACK TO SAVEPOINT, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>ROUND function datetime, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_arithmetic">Functions for Datetime Arithmetic</a>
</dt>
<dt>ROUND number function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>ROUTINE_COLUMN_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROUTINE_JAR_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROUTINE_PRIVILEGES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROUTINE_ROUTINE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROUTINE_SEQUENCE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROUTINE_TABLE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>routine body, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_definition">Routine Definition</a>
</dt>
<dt>routine invocation, <a class="indexterm" href="dataaccess-chapt.html#dac_other_syntax_elements">Other Syntax Elements</a>
</dt>
<dt>ROUTINES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>ROW_NUMBER function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>ROWNUM function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>row value expression, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>RPAD function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>RTRIM function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>S</h3>
<dl>
<dt>SAVEPOINT, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SAVEPOINT LEVEL, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_characteristics">Routine Characteristics</a>
</dt>
<dt>schema routine, <a class="indexterm" href="databaseobjects-chapt.html#dbc_routine_creation">Routine Creation</a>
</dt>
<dt>SCHEMATA, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>SCRIPT, <a class="indexterm" href="management-chapt.html#mtc_system_operations">System Operations</a>
</dt>
<dt>search condition, <a class="indexterm" href="dataaccess-chapt.html#dac_other_syntax_elements">Other Syntax Elements</a>
</dt>
<dt>SECOND function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>SECONDS_SINCE_MIDNIGHT function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>security, <a class="indexterm" href="running-chapt.html#rgc_security">Security Considerations</a>, <a class="indexterm" href="listeners-chapt.html#lsc_tls">TLS Encryption</a>, <a class="indexterm" href="listeners-chapt.html#lsc_acl">Network Access Control</a>
</dt>
<dt>SELECT, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_select_statement">Select Statement</a>
</dt>
<dt>SELECT : SINGLE ROW, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_select_single">Select Statement : Single Row</a>
</dt>
<dt>SEQUENCE_ARRAY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_array_functions">Array Functions</a>
</dt>
<dt>SEQUENCES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>SESSION_ID function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>SESSION_ISOLATION_LEVEL function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>SESSION_TIMEZONE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_timezone_functions">Functions to Report the Time Zone.</a>
</dt>
<dt>SESSION_USER function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>SET AUTOCOMMIT, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET CATALOG, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>set clause in UPDATE and MERGE statements, <a class="indexterm" href="dataaccess-chapt.html#dac_update_statement">Update Statement</a>
</dt>
<dt>SET CONSTRAINTS, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET DATABASE AUTHENTICATION FUNCTION, <a class="indexterm" href="management-chapt.html#mtc_authntication_settings">Authentication Settings</a>
</dt>
<dt>SET DATABASE COLLATION, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATABASE DEFAULT INITIAL SCHEMA, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>SET DATABASE DEFAULT ISOLATION LEVEL, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATABASE DEFAULT RESULT MEMORY ROWS, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATABASE DEFAULT TABLE TYPE, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATABASE EVENT LOG LEVEL, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATABASE GC, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATABASE PASSWORD CHECK FUNCTION, <a class="indexterm" href="management-chapt.html#mtc_authntication_settings">Authentication Settings</a>
</dt>
<dt>SET DATABASE SQL AVG SCALE, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL CONCAT NULLS, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL CONVERT TRUNCATE, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL DOUBLE NAN, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL NAMES, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL NULLS FIRST, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL REFERENCES, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL REGULAR NAMES, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL SIZE, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL SYNTAX DB2, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL SYNTAX MSS, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL SYNTAX MYS, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL SYNTAX ORA, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL SYNTAX PGS, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL TDC DELETE, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL TRANSLATE TTI TYPES, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL TYPES, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE SQL UNIQUE NULLS, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET DATABASE TEXT TABLE DEFAULTS, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATABASE TRANSACTION CONTROL, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATABASE TRANSACTION ROLLBACK ON CONFLICT, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATABASE UNIQUE NAME, <a class="indexterm" href="management-chapt.html#mtc_database_settings">Database Settings</a>
</dt>
<dt>SET DATA TYPE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>SET DEFAULT, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>SET DOMAIN DEFAULT, <a class="indexterm" href="databaseobjects-chapt.html#dbc_domain_creation">Domain Creation and Manipulation</a>
</dt>
<dt>SET FILES BACKUP INCREMENT, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES CACHE ROWS, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES CACHE SIZE, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES DEFRAG, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES LOB SCALE, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES LOG, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES LOG SIZE, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES NIO, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES NIO SIZE, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES SCALE, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES SCRIPT FORMAT, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET FILES WRITE DELAY, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>set function specification, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>SET IGNORECASE, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET INITIAL SCHEMA*, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>SET MAXROWS, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET OPERATIONS, <a class="indexterm" href="dataaccess-chapt.html#dac_set_operations">Set Operations</a>
</dt>
<dt>SET PASSWORD, <a class="indexterm" href="accesscontrol-chapt.html#acc_statements">Statements for
Authorization and Access Control</a>
</dt>
<dt>SET PATH, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET REFERENTIAL INTEGRITY, <a class="indexterm" href="management-chapt.html#mtc_sql_settings">SQL Conformance Settings</a>
</dt>
<dt>SET ROLE, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET SCHEMA, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET SESSION AUTHORIZATION, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET SESSION CHARACTERISTICS, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET SESSION RESULT MEMORY ROWS, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET TABLE CLUSTERED, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>SET TABLE read-write property, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>SET TABLE SOURCE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>SET TABLE SOURCE HEADER, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>SET TABLE SOURCE on-off, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>
</dt>
<dt>SET TABLE TYPE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_manupulation">Table Manipulation</a>, <a class="indexterm" href="management-chapt.html#mtc_cache_persistence">Cache, Persistence and Files Settings</a>
</dt>
<dt>SET TIME ZONE, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SET TRANSACTION, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>SHUTDOWN, <a class="indexterm" href="management-chapt.html#mtc_system_operations">System Operations</a>
</dt>
<dt>SIGNAL STATEMENT, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_exceptions">Raising Exceptions</a>
</dt>
<dt>SIGN function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>SIN function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>SORT_ARRAY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_array_functions">Array Functions</a>
</dt>
<dt>sort specification list, <a class="indexterm" href="dataaccess-chapt.html#dac_ordering">Ordering</a>
</dt>
<dt>SOUNDEX function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>SPACE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>SPECIFIC, <a class="indexterm" href="databaseobjects-chapt.html#dbc_common_elements">Common Elements and Statements</a>
</dt>
<dt>SPECIFIC NAME, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_characteristics">Routine Characteristics</a>
</dt>
<dt>SQL_FEATURES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>SQL_IMPLEMENTATION_INFO, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>SQL_PACKAGES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>SQL_PARTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>SQL_SIZING, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>SQL_SIZING_PROFILES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>SQL DATA access characteristic, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_characteristics">Routine Characteristics</a>
</dt>
<dt>SQL parameter reference, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_references">References, etc.</a>
</dt>
<dt>SQL procedure statement, <a class="indexterm" href="databaseobjects-chapt.html#dbc_procedure_satement">SQL Procedure Statement</a>
</dt>
<dt>SQL routine body, <a class="indexterm" href="sqlroutines-chapt.html#src_routine_definition">Routine Definition</a>
</dt>
<dt>SQRT function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>START TRANSACTION, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>string value expression, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>SUBSTR function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>SUBSTRING function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>SYSDATE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>SYSTEM_BESTROWIDENTIFIER, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_CACHEINFO, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_COLUMN_SEQUENCE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_COLUMNS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_COMMENTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_CONNECTION_PROPERTIES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_CROSSREFERENCE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_INDEXINFO, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_PRIMARYKEYS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_PROCEDURECOLUMNS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_PROCEDURES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_PROPERTIES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_SCHEMAS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_SEQUENCES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_SESSIONINFO, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_SESSIONS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_TABLES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_TABLETYPES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_TEXTTABLES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_TYPEINFO, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_UDTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_USER function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>SYSTEM_USERS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTEM_VERSIONCOLUMNS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_hypersql_views_info_schema">HyperSQL Custom Views</a>
</dt>
<dt>SYSTIMESTAMP function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>SYS USER, <a class="indexterm" href="accesscontrol-chapt.html#acc_built_in_roles_users">Built-In Roles and Users</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>T</h3>
<dl>
<dt>TABLE, <a class="indexterm" href="dataaccess-chapt.html#dac_table_primary">Table Primary</a>
</dt>
<dt>TABLE_CONSTRAINTS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TABLE_PRIVILEGES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TABLES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TAN function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>TIMESTAMPADD function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_arithmetic">Functions for Datetime Arithmetic</a>
</dt>
<dt>TIMESTAMPDIFF function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_arithmetic">Functions for Datetime Arithmetic</a>
</dt>
<dt>TIMESTAMP function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_format">Functions to Convert or Format a Datetime</a>
</dt>
<dt>Time Zone, <a class="indexterm" href="sqlgeneral-chapt.html#sgc_datetime_types">Datetime types</a>
</dt>
<dt>TIMEZONE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_timezone_functions">Functions to Report the Time Zone.</a>
</dt>
<dt>TO_CHAR function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_format">Functions to Convert or Format a Datetime</a>
</dt>
<dt>TO_DATE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_format">Functions to Convert or Format a Datetime</a>
</dt>
<dt>TO_NUMBER function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>TO_TIMESTAMP function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_format">Functions to Convert or Format a Datetime</a>
</dt>
<dt>TODAY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_current_datetime">Functions to Report the Current Datetime</a>
</dt>
<dt>TRANSACTION_CONTROL function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>TRANSACTION_ID function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>TRANSACTION_SIZE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>transaction characteristics, <a class="indexterm" href="sessions-chapt.html#snc_statements">Session and Transaction Control Statements</a>
</dt>
<dt>TRANSLATIONS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TRIGGER_COLUMN_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TRIGGER_ROUTINE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TRIGGER_SEQUENCE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TRIGGER_TABLE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TRIGGERED_UPDATE_COLUMNS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TRIGGERED SQL STATEMENT, <a class="indexterm" href="triggers-chapt.html#trc_trigger_creation">Trigger Creation</a>
</dt>
<dt>TRIGGER EXECUTION ORDER, <a class="indexterm" href="triggers-chapt.html#trc_trigger_creation">Trigger Creation</a>
</dt>
<dt>TRIGGERS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>TRIM_ARRAY function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_array_functions">Array Functions</a>
</dt>
<dt>TRIM function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>TRUNCATE function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
<dt>TRUNCATE SCHEMA, <a class="indexterm" href="dataaccess-chapt.html#dac_truncate_statement">Truncate Statement</a>
</dt>
<dt>TRUNCATE TABLE, <a class="indexterm" href="dataaccess-chapt.html#dac_truncate_statement">Truncate Statement</a>
</dt>
<dt>TRUNC function datetime, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_datetime_arithmetic">Functions for Datetime Arithmetic</a>
</dt>
<dt>TRUNC function numeric, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>U</h3>
<dl>
<dt>UCASE function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>unicode escape elements, <a class="indexterm" href="dataaccess-chapt.html#dac_literals">Literals</a>
</dt>
<dt>UNION JOIN, <a class="indexterm" href="dataaccess-chapt.html#dac_joined_table">Joined Table</a>
</dt>
<dt>UNIQUE constraint, <a class="indexterm" href="databaseobjects-chapt.html#dbc_table_creation">Table Creation</a>
</dt>
<dt>UNIQUE predicate, <a class="indexterm" href="dataaccess-chapt.html#dac_sql_predicates">Predicates</a>
</dt>
<dt>UNIX_TIMESTAMP function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>UNNEST, <a class="indexterm" href="dataaccess-chapt.html#dac_table_primary">Table Primary</a>
</dt>
<dt>UPDATE, <a class="indexterm" href="dataaccess-chapt.html#dac_update_statement">Update Statement</a>
</dt>
<dt>upgrading, <a class="indexterm" href="deployment-chapt.html#dec_upgrade_database">Upgrading Databases</a>
</dt>
<dt>UPPER function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_string_binary_functions">String and Binary String Functions</a>
</dt>
<dt>USAGE_PRIVILEGES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>USER_DEFINED_TYPES, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>USER function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_system_functions">System Functions</a>
</dt>
<dt>UUID function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_general_functions">General Functions</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>V</h3>
<dl>
<dt>value expression, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>value expression primary, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>value specification, <a class="indexterm" href="dataaccess-chapt.html#dac_value_expression">Value Expression</a>
</dt>
<dt>VIEW_COLUMN_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>VIEW_ROUTINE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>VIEW_TABLE_USAGE, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
<dt>VIEWS, <a class="indexterm" href="databaseobjects-chapt.html#dbc_standard_views_info_schema">SQL Standard Views</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>W</h3>
<dl>
<dt>WEEK function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
<dt>WHILE loop in routines, <a class="indexterm" href="sqlroutines-chapt.html#src_psm_iterated_statements">Iterated Statements</a>
</dt>
<dt>WIDTH_BUCKET function, <a class="indexterm" href="builtinfunctions-chapt.html#builtin_functions_numeric_sect">Numeric Functions</a>
</dt>
</dl>
</div>
<div class="indexdiv">
<h3>Y</h3>
<dl>
<dt>YEAR function, <a class="indexterm" href="builtinfunctions-chapt.html#bfc_extract_datetime">Functions to Extract an Element of a Datetime</a>
</dt>
</dl>
</div>
</div>
</div>
<HR xmlns:xi="http://www.w3.org/2001/XInclude">
<P xmlns:xi="http://www.w3.org/2001/XInclude" class="svnrev">$Revision: 4864 $</P>
<div class="navfooter">
<hr>
<table summary="Navigation footer" width="100%">
<tr>
<td align="left" width="40%"><a accesskey="p" href="sql-ind.html"><img src="../images/db/prev.png" alt="Prev"></a> </td><td align="center" width="20%"> </td><td align="right" width="40%"> </td>
</tr>
<tr>
<td valign="top" align="left" width="40%">SQL Index </td><td align="center" width="20%"><a accesskey="h" href="index.html"><img src="../images/db/home.png" alt="Home"></a></td><td valign="top" align="right" width="40%"> </td>
</tr>
</table>
</div>
</body>
</html>
