Navigator Systems Nexus SQL Database Server

Contents | Index | Search

- - -

- (subtraction operator)

- # -

# (temporary table)

## (temporary table)

#L+ option

- ( -

(### (temporary table)

- * -

* (asterisk)

* (multiplication operator)

- / -

/ (division operator)

- | -

|| (concatenation operator)

- + -

+ (addition operator)

- < -

< (less than operator)

<= (ess than or equals operator)

<> (not equals operator)

<absolute value expression>

<add column definition>

<add table constraint definition>

<addition operator>

<aggregate function>

<alter column action>

<alter column definition>

<alter table action>

<alter table statement>

<approximate numeric literal>

<approximate numeric type>

<arctangent function>

<as subquery clause>

<assembly definition>

<assembly specifier>

<assert table statement>

<assignment operator>

<assignment source>

<assignment statement>

<assignment target>

<between predicate part 2>

<between predicate>

<binary large object string type>

<binary string literal>

<blob position expression>

<blob primary>

<blob switch>

<blob value expression>

<boolean AND operator>

<boolean factor>

<boolean literal>

<boolean NOT operator>

<boolean OR operator>

<boolean predicand>

<boolean primary>

<boolean term>

<boolean test>

<boolean type>

<boolean value expression>

<case abbreviation>

<case expression>

<case operand>

<case specification>

<cast operand>

<catch clause>

<catch statement block>

<ceiling function>

<char function>

<char length expression>

<char length units>

<character large object type>

<character like predicate part 2>

<character pattern>

<character primary>

<character representation>

<character set clause>

<character string literal>

<character string type>

<character substring function>

<character value expression>

<character value function>

<check constraint definition>

<collate clause>

<collation clause>

<column constraint definition>

<column constraint>

<column definition>

<commit statement>

<common value expression>

<comp op>

<compare flag>

<comparison predicate part 2>

<comparison predicate>

<compound statement>

<concatenation operator>

<constraint name definition>

<contextually typed row value constructor element list>

<contextually typed row value constructor element>

<contextually typed row value constructor>

<contextually typed row value expression list>

<contextually typed row value expression>

<contextually typed table value constructor>

<contextually typed value specification>

<cosine function>

<cross join>

<current date value function>

Current Date Function Current Time Function

<current timestamp value function>

<cursor specification>

<data type>

<date literal>

<date string>

<datetime literal>

<datetime primary>

<datetime type>

<datetime value expression>

<datetime value function>

<day-time interval>

<day-time literal>

<default clause>

<default option>

<default specification>

<delete rule>

<delete statement: searched>

<deleting predicate>

<derived column list>

<deterministic characteristic>

<digit>

<division operator>

<drop assembly statement>

<drop column definition>

<drop index statement>

<drop routine statement>

<drop table constraint definition>

<drop table statement>

<drop trigger statement>

<drop view statement>

DROP ALIAS statement DROP VIEW statement

<dynamic parameter specification>

<else clause>

<equals operator>

<equivalent predicate>

<exact numeric literal>

<exact numeric type>

<exists predicate>

<explicit row value constructor>

<exponent>

<exponential function>

<external body reference>

<extract expression>

<extract field>

<extract source>

<factor>

<floor function>

<fold>

<from clause>

<from constructor>

<from subquery>

<general literal>

<general set function>

<general value specification>

<greater than operator>

<greater than or equals operator>

<group by clause>

<guid literal>

<having clause>

<hexit>

<if statement elseif clause>

<if statement then clause>

<if statement>

<in predicate part 2>

<in predicate value>

<in predicate>

<index definition>

<index element>

<index switch>

<insert columns and source>

<insert statement>

<inserting predicate>

<interval literal>

<interval qualifier>

<interval string>

<iterate statement>

<join specification>

<join type>

<joined table>

<language clause>

<leave statement>

<length expression>

<less than operator>

<less than or equals operator>

<like clause>

<like predicate>

<literal>

<local declaration list>

<log switch>

<mantissa>

<match predicate part 2>

<match predicate>

<modulus expression>

<multiplication operator>

<national character large object type>

<national character string literal>

<national character string type>

<natural join>

<natural logarithm>

<nonparenthesized value expression primary>

<non-second primary datetime field>

<not equals operator>

<null ordering>

<null predicate part 2>

<null predicate>

<null specification>

<numeric primary>

<numeric type>

<numeric value expression dividend>

<numeric value expression divisor>

<numeric value expression>

<numeric value function>

<octet length expression>

<odd predicate>

<order by clause>

<ordinal function>

<parameter mode>

<pi function>

<position expression>

<power function>

<predicate>

<primary datetime field>

<protected statement block>

<qualified join>

<quantified comparison predicate part 2>

<quantified comparison predicate>

<quantifier>

<query expression>

<query specification>

<query term>

<quote symbol>

<quote>

<random function>

<references specification>

<referential action>

<referential constraint definition>

<referential triggered action>

<repeat statement>

<result>

<return statement>

<return value>

<rollback statement>

<round function>

<routine body>

<routine characteristic>

<routine characteristics>

<routine invocation>

<row subquery>

<row value constructor element list>

<row value constructor element>

<row value constructor predicand>

<row value expression>

<row value predicand>

<scalar subquery>

<search condition>

<searched when clause>

<select list>

<select statement>

<select sublist>

<set clause list>

<set function type>

<set passwords statement>

<signal statement>

<signed integer>

<signed numeric literal>

<simple when clause>

<simplify switch>

<sine function>

<sort direction>

<sort options>

<sort specification>

<SQL argument list>

<SQL argument>

<SQL control statement>

<SQL data change statement>

<SQL data statement>

<SQL parameter declaration list>

<SQL parameter declaration>

<SQL procedure statement>

<SQL routine body>

<SQL schema definition statement>

<SQL schema manipulation statement>

<SQL schema statement>

<SQL session statement>

<SQL statement list>

<SQL transaction statement>

<SQL variable declaration>

DECLARE CURSOR statement DECLARE variable statement

<SQL variable name list>

DECLARE CURSOR statement DECLARE variable statement

<SQL-data access indication>

<SQL-invoked routine>

<square root>

<start transaction statement>

<string position expression>

<string value expression>

<string value function>

<subquery>

<subtraction operator>

<table constraint definition>

<table constraint>

<table contents source>

<table definition>

<table element>

<table expression>

<table factor>

<table function derived table>

<table reference>

<table subquery>

<target specification>

<term>

<time interval>

<time literal>

<time string>

<timeout switch>

<timestamp literal>

<timestamp string>

<tostring function>

<tostringlen function>

<transaction mode>

<transition variable>

<trigger column list>

<trigger definition>

<trigger event>

<triggered SQL statement>

<trim character>

<trim function>

<trim source>

<trim specification>

<truth value>

<try statement>

<unique constraint definition>

<unique predicate>

<unsigned integer>

<unsigned literal>

<unsigned numeric literal>

<unsigned value specification>

<update rule>

<update source>

<update statement: searched>

<updating predicate>

<user-defined function>

<user-defined procedure>

<value expression primary>

<value expression>

<value specification>

<view definition>

<view specification>

<when operand>

<where clause>

<while statement>

<year-month literal>

- = -

= (assigment operator)

= (equals operator)

- > -

> (greater than operator)

>= (greater than or equals operator)

- A -

About NexusDB SQL Reference

ABS

Absolute Value Expression

Active Query

ADD

ALTER TABLE statement SET PASSWORDS statement

Add column definition

Add table constraint definition

Advanced settings

AFTER

Aggregate Functions

ALL

Aggregate Functions Quantified Comparison Predicate SELECT statement

ALTER

Alter column definition

ALTER TABLE statement

AND

Operators Boolean Value Expressions Between Predicate

ANY

Appendices

Additional SQL:2003 Features

Core SQL:2003 Features

Approximate Numeric Literal

Approximate Numeric Type

Arctangent Function

Arithmethic operators

AS

Cast Specification CREATE TABLE statement CREATE VIEW statement CREATE TRIGGER statement CREATE PROCEDURE statement CREATE FUNCTION statement SELECT statement UPDATE statement DELETE statement

AS subquery clause

ASC

ASSEMBLY

CREATE ASSEMBLY statement DROP ASSEMBLY statement

ASSERT

ASSERT TABLE statement

ATAN

ATAN2

ATN2

ATOMIC

Attach

AUTHORIZATION

AUTOINC

AutoInc Engine

AVG

- B -

BEFORE

BEGIN

BETWEEN

Between Predicate

BIGINT

BINARY

BINARY LARGE OBJECT

Binary Large Object String Type

Binary String Literal

BLOB

Blob Fields

Browsing a Table The Table View Menu Using SQL The Query View Menu

BLOB Graphic

BLOB Memo

Blob Value Expression

BLOCK

Block Size

BLOCKSIZE

BOOL

BOOLEAN

Boolean Literals

Boolean operators

Boolean Types

Boolean Value Expressions

BOTH

BROUND

Browse Table

browser window

Browsing Table Data

BY

BYTE

Byte Array

BYTEARRAY

- C -

CALL

CALL statement

CALLED

CALLED ON NULL INPUT

Can't open tablename

CASCADE

CASE

Case Expressions Like Predicate CREATE INDEX statement

Case Expressions

CAST

Cast Specification

CATCH

CEIL

CEILING

Ceiling Function

CHAR

Field Types String Types

Char Function

CHAR LARGE OBJECT

CHAR VARYING

CHAR_LENGTH

CHARACTER

SQL Data Types String Types

CHARACTER LARGE OBJECT

Character Large Object Type

CHARACTER SET

Character sets and collations

Character String Literal

Character String Type

Character Value Expression

CHARACTER VARYING

CHARACTER_LENGTH

CHARACTERS

Position Expression Length Expression Substring Function

CHECK

CHR

Clear Range

CLOB

Clone Table

CLR

CLR routines

COALESCE

CODEPAGE

COLLATE

COLLATION

COLUMN

Column constraint

Column definition

column names

Step One - File Type Step Three - Field Formats and Advanced Options

Comments

COMMIT

COMMIT statement

Commit Transaction

Comparison operators

Comparison Predicate

Compound statement

Concatenation operators

connection to a server

CONSTRAINT

CREATE TABLE statement ALTER TABLE statement

CONTAINS

CONTAINS SQL

Control Statements

About Control Statements

CALL statement

Compound statement

DECLARE CURSOR statement

DECLARE variable statement

IF statement

ITERATE statement

LEAVE statement

REPEAT statement

RETURN statement

SET statement

SIGNAL statement

TRY statement

WHILE statement

Copy To Table

The Table Menu The Query Menu

COS

Cosine Function

COUNT

CREATE

CREATE ASSEMBLY statement

CREATE FUNCTION statement

CREATE INDEX statement

CREATE PROCEDURE statement

CREATE TABLE statement

CREATE TRIGGER statement

CREATE VIEW statement

create new Tables

Create table

CROSS

CROSS JOIN

CSV Import

The Database Context Menu The Table Context Menu

CSV Import Wizard

Current Date Function

Current Time Function

Current Timestamp Function

CURRENT_DATE

Current Date Function CREATE TABLE statement

CURRENT_TIME

Current Time Function CREATE TABLE statement

CURRENT_TIMESTAMP

Current Timestamp Function CREATE TABLE statement

CURRENT_USER

Value Expressions System Functions CREATE TABLE statement

Cursor specification

Cursors

- D -

DATA

SQL-Invoked Routines CREATE TABLE statement

data grid

Using the Data Grid Browsing a Table Using SQL

Data Loss Action

Data Statements

About Data Statements

DELETE statement

INSERT statement

SELECT statement

UPDATE statement

Data types

Database List

Database Popup Menu

DATE

DateTime Literals DateTime Types

Date Literal

date/time formats

DATETIME

DateTime Literals

DateTime Types

DateTime Value Expressions

DateTime Value Functions

About DateTime Value Functions

Current Date Function

Current Time Function

Current Timestamp Function

DAY

Day-Time Interval

Day-Time Literal

DEC

DECIMAL

DECLARE

DECLARE CURSOR statement DECLARE variable statement

DECLARE CURSOR statement

DECLARE variable statement

DEFAULT

Row Value Expressions CREATE TABLE statement ALTER TABLE statement INSERT statement

Default Timeout

Introduction Global Options

DELETE

CREATE TABLE statement CREATE TRIGGER statement DELETE statement

Delete all the records

Delete Database Alias

Delete Records

DELETE statement

Delete Table

DELETING

Deleting Predicate

DESC

DESCRIPTION

CREATE TABLE statement CREATE TRIGGER statement CREATE PROCEDURE statement CREATE FUNCTION statement ALTER TABLE statement

Design Report

The Table Menu The Query Menu Printing Reports

DETERMINISTIC

disk fragmentation

DISTINCT

Aggregate Functions SELECT statement

DO

DOUBLE

DOUBLE PRECISION

DROP

DROP ALIAS statement

DROP ASSEMBLY statement

DROP FUNCTION statement

DROP INDEX statement

DROP PROCEDURE statement

DROP ROUTINE statement

DROP TABLE statement

DROP TRIGGER statement

DROP VIEW statement

Drop column definition

Drop table constraint definition

DWORD

- E -

EACH

Edit Range

ELSE

Case Expressions IF statement

ELSEIF

embedded server

EMPTY

Empty All Tables

ENCRYPT

encrypt tables

ENCRYPT WITH

ENCRYPTION

Encryption Engine

END

Case Expressions Compound statement IF statement REPEAT statement WHILE statement TRY statement

END IF

END REPEAT

END WHILE

ENGINE

EQUIVALENT

Equivalent Predicate

ERROR_MESSAGE

System Functions TRY statement

ESCAPE

Exact Numeric Literal

Exact Numeric Type

EXCEPT

execution plan

Using SQL The Query View Menu

EXISTS

Exists Predicate ALTER TABLE statement DROP ALIAS statement DROP TABLE statement DROP INDEX statement DROP VIEW statement DROP TRIGGER statement DROP ROUTINE statement DROP ASSEMBLY statement

Exists Predicate

EXP

Exponential Function

EXTENDED

EXTERNAL

EXTRACT

Extract Expression

- F -

FALSE

Boolean Literals Boolean Types Boolean Value Expressions

FastReports

Field Descriptors

field map

field Name

field Type

Field Types

File Descriptors

File Extension

File Type

Find Nearest

FIRST

fixed width formats

FLOAT

floating point fields

FLOOR

Floor Function

Fold Function

FOR

Substring Function CREATE TRIGGER statement

FOR EACH

FOREIGN

FOREIGN KEY

formatting options

FROM

Extract Expression Substring Function Trim Function CREATE ASSEMBLY statement SELECT statement DELETE statement

FULL

Match Predicate SELECT statement

FULL JOIN

FUNCTION

CREATE FUNCTION statement DROP ROUTINE statement

Functions

About Functions

Aggregate Functions

DateTime Value Functions

Numeric Value Functions

String Value Functions

System Functions

- G -

GLOBAL

Global Defaults

global options

Introduction Global Options Using SQL

GROUP

GROUP BY

Grouping Data

GROW

Grow Blocks

GROWSIZE

GUID

GUID Literal

- H -

HAVING

Heartbeat Frequency

Introduction Global Options

HOUR

- I -

Identifiers

IDENTITY

IF

ALTER TABLE statement DROP ALIAS statement DROP TABLE statement DROP INDEX statement DROP VIEW statement DROP TRIGGER statement DROP ROUTINE statement DROP ASSEMBLY statement IF statement

IF EXISTS

ALTER TABLE statement DROP ALIAS statement DROP TABLE statement DROP INDEX statement DROP VIEW statement DROP TRIGGER statement DROP ROUTINE statement DROP ASSEMBLY statement

IF statement

IGNORE

SQL Data Types Like Predicate CREATE INDEX statement

IGNORE CASE

IMAGE

IN

Position Expression In Predicate SQL-Invoked Routines

In Predicate

INDEX

CREATE INDEX statement

DROP INDEX statement

Index Descriptors

indexed value

Information Schema

System Tables

INITIAL

Initial Blocks

INITIALSIZE

INNER

INNER JOIN

INOUT

INPUT

INSERT

CREATE TRIGGER statement INSERT statement

INSERT INTO

INSERT statement

INSERTING

Inserting Predicate

INT

INTEGER

Internal Server

INTERSECT

INTERVAL

Interval Literals

INTO

SELECT statement INSERT statement

Introduction

IS

Boolean Value Expressions Null Predicate

ITERATE

ITERATE statement

- J -

JOIN

Join specification

- K -

KANA

KANA TYPE

KEY

Keywords

- L -

LANGUAGE

LARGE

LARGEINT

LAST

LASTAUTOINC

LastAutoinc Function

LEADING

LEAVE

LEAVE statement

LEFT

LEFT JOIN

Length Expression

LIKE

LIKE clause

Like Predicate

LIST

Literals

About Literals

Boolean Literals

DateTime Literals

Interval Literals

Numeric Literals

String Literals

Live Backup

Live Dataset

Live Datasets

live queries

LN

LOCAL

LOCALE

Locale Descriptor

LOCALTIME

Current Time Function CREATE TABLE statement

LOCALTIMESTAMP

Current Timestamp Function CREATE TABLE statement

log window

loss of data

LOWER

- M -

maintenance

Map From Field

MATCH

Match Predicate

MAX

MED

MIN

MINUTE

MOD

MODIFIES

MODIFIES SQL DATA

Modulus Expression

MONEY

MONTH

Multi-statement scripts

- N -

NAME

NATIONAL

NATIONAL CHAR

NATIONAL CHAR VARYING

NATIONAL CHARACTER

NATIONAL CHARACTER LARGE OBJECT

National Character Large Object Type

National Character String Literal

National Character String Type

NATIONAL CHARACTER VARYING

NATURAL

Natural Logarithm

NCHAR

NCHAR LARGE OBJECT

NCHAR VARYING

NCLOB

NEW

New Database Alias

Server Context Menu The Database Context Menu

New Table

The Database Context Menu The Table Context Menu

NEWGUID

Value Expressions System Functions CREATE TABLE statement

Next Table

NO

SQL-Invoked Routines CREATE TABLE statement

NO DATA

NO SQL

non-null

NONSPACE

NOT

Operators Boolean Value Expressions Between Predicate In Predicate Like Predicate Null Predicate SQL-Invoked Routines CREATE TABLE statement ALTER TABLE statement Compound statement

NOT DETERMINISTIC

NOT NULL

CREATE TABLE statement ALTER TABLE statement

NSINGLECHAR

NULL

Row Value Expressions Case Expressions Cast Specification Null Predicate SQL-Invoked Routines CREATE TABLE statement ALTER TABLE statement RETURN statement

Null Predicate

Null Values

NULLIF

NULLS

NULLSTRING

NUMERIC

Numeric Literals

Numeric Types

Numeric Value Expressions

Numeric Value Functions

About Numeric Value Functions

Absolute Value Expression

Arctangent Function

Ceiling Function

Cosine Function

Exponential Function

Extract Expression

Floor Function

LastAutoinc Function

Length Expression

Modulus Expression

Natural Logarithm

Ordinal Function

PI Function

Position Expression

Power Function

Random Function

Round Function

Sine Function

Square Root Function

NVARCHAR

- O -

OBJECT

OCTET_LENGTH

OCTETS

Position Expression Length Expression Substring Function

ODD

Odd Predicate

OF

OLD

ON

SQL-Invoked Routines CREATE TABLE statement CREATE INDEX statement CREATE TRIGGER statement SELECT statement

Operator precedence

Operators

Optimistic Locks

Introduction Global Options

Optimistic Recordlocks

OR

Operators Boolean Value Expressions

ORD

ORDER

ORDER BY

Ordinal Function

OUT

OUTER

- P -

Pack All Tables

Pack Table

Parameter values

Parameters

PARTIAL

PASSWORDS

PERCENT

PI

PI Function

POSITION

Position Expression

POWER

Power Function

PRECISION

Predefined Data Types

Predicates

About Predicates

Between Predicate

Comparison Predicate

Deleting Predicate

Equivalent Predicate

Exists Predicate

In Predicate

Inserting Predicate

Like Predicate

Match Predicate

Null Predicate

Odd Predicate

Quantified Comparison Predicate

Unique Predicate

Updating Predicate

Prepared Statements

PRIMARY

PRIMARY KEY

Print Preview

The Table Menu The Query Menu Printing Reports

PROCEDURE

CREATE PROCEDURE statement DROP ROUTINE statement

Procedure Language

- Q -

Quantified Comparison Predicate

Query expression

Query Menu

query name

Query Options Menu

query property

Query specification

Query View Menu

Query Window

- R -

RAND

Random Function

read-only

Readonly Datasets

Introduction Global Options

READS

READS SQL DATA

REAL

Rearrange Columns

RecNo Support

Introduction Global Options

Record Count

Record Engine

Recover Records

RECREV

Redefine

REFERENCES

REFERENCING

Referential constraint definition

Refresh Database List

Refresh Server List

Refresh Table List

Register Server

regular identifier

Regular Identifiers

REMOVE

Rename Database Alias

Rename Table

REPEAT

REPEAT statement

Reset Columns

Resize Column Widths

RESTRICT

CREATE TABLE statement ALTER TABLE statement DROP ALIAS statement DROP TABLE statement DROP VIEW statement DROP ROUTINE statement

restrict the data

Result data types of aggregations

RETURN

RETURN statement

RETURNS

SQL-Invoked Routines CREATE FUNCTION statement

RETURNS NULL ON NULL INPUT

reusing values

RIGHT

RIGHT JOIN

ROLLBACK

ROLLBACK statement

Rollback Transaction

ROUND

Round Function

ROUTINE

Routine Characteristics

Routine Invocation

ROW

Row subquery

Row Value Expressions

ROWSAFFECTED

Value Expressions System Functions

ROWSREAD

Value Expressions System Functions

Runtime Loaded Packages

Introduction Global Options

- S -

Scalar subquery

Schema Statements

About Schema Statements

ALTER TABLE statement

CREATE ASSEMBLY statement

CREATE FUNCTION statement

CREATE INDEX statement

CREATE PROCEDURE statement

CREATE TABLE statement

CREATE TRIGGER statement

CREATE VIEW statement

DROP ALIAS statement

DROP ASSEMBLY statement

DROP INDEX statement

DROP ROUTINE statement

DROP TABLE statement

DROP TRIGGER statement

DROP VIEW statement

search condition

SECOND

SELECT

SELECT statement

Sequential Access Index

SERIALIZABLE

Server List

Server Popup Menu

Server Statistics

Servers Window

server-side resources

Session Statements

About Session Statements

SET PASSWORDS statement

SESSION_USER

Value Expressions System Functions CREATE TABLE statement

SET

CREATE TABLE statement ALTER TABLE statement UPDATE statement SET PASSWORDS statement SET statement

Set AutoInc

SET DEFAULT

Set Field to Null

SET NULL

Set Password

The Database Context Menu The Table Context Menu

SET PASSWORDS statement

Set Range

SET statement

Set Timeout

SHORTINT

SHORTSTRING

Show Blob Fields

The Table View Menu The Query View Menu

Show Filter

Show Range

Show Record Count

SIGNAL

SIGNAL statement

SIMPLE

SIN

Sine Function

SINGLECHAR

SMALLINT

SNAPSHOT

SOME

SORT

Sorting Data

Special Statements

About Special Statements

ASSERT TABLE statement

SQL

SQL Data Types

About SQL Data Types

Boolean Types

DateTime Types

Numeric Types

Overview of Predefined Data Types

String Types

SQL extensions

SQL Language Elements

About SQL Language Elements

Comments

Identifiers

Keywords

Literals

Null Values

Operators

Parameters

Value Expressions

SQL Parameter Declaration

SQL Procedure Statements

SQL routines

SQL script

SQL scripts

SQL Statements

About SQL Statements

Control Statements

Data Statements

Prepared Statements

Schema Statements

Session Statements

Special Statements

Statement Switches

Transaction Statements

SQL:2003

SQL-Invoked Routines

SQRT

Square Root Function

START

Start Transaction

START TRANSACTION statement

Statement Switches

STD

STORAGE

STORAGE ENGINE

Stored Procedures and Functions

About Stored Procedures and Functions

Procedure Language

SQL Procedure Statements

SQL-Invoked Routines

STRING

String Literals

String Types

String Value Expressions

String Value Functions

About String Value Functions

Char Function

Fold Function

Substring Function

Tostring Function

Tostringlen Function

Trim Function

strong encryption

Subquieries

SUBSTRING

Substring Function

SUM

SYMBOLS

syntax highlighting

System Functions

SYSTEM_ROW#

Value Expressions System Functions

- T -

TABLE

CREATE FUNCTION statement SELECT statement ASSERT TABLE statement

ALTER TABLE statement

CREATE TABLE statement

DROP TABLE statement

Table constraint

Table expression

Table List

Table Menu

Table name

Table operators

Table Options Menu

Table Popup Menu

Table reference

Table subquery

Table View Menu

TEMPORARY

Temporary tables

TEXT

THEN

Case Expressions IF statement

TIME

DateTime Literals DateTime Types

Time Interval

Time Literal

TIMESTAMP

DateTime Literals DateTime Types

Timestamp Literal

TINYINT

TO

TOP

TOSTRING

Tostring Function

TOSTRINGLEN

Tostringlen Function

TRAILING

TRANSACTION

Transaction Statements

About Transaction Statements

COMMIT statement

ROLLBACK statement

START TRANSACTION statement

transport type

TRIGGER

CREATE TRIGGER statement

DROP TRIGGER statement

TRIM

Trim Function

TRUE

Boolean Literals Boolean Types Boolean Value Expressions

TRY

TRY statement

TYPE

- U -

UNION

UNIQUE

Unique Predicate Match Predicate CREATE TABLE statement CREATE INDEX statement

Unique Predicate

UNKNOWN

Boolean Literals Boolean Types Boolean Value Expressions

UNTIL

UPDATE

CREATE TABLE statement CREATE TRIGGER statement UPDATE statement

UPDATE statement

UPDATE statements

UPDATING

Updating Predicate

UPPER

USE

USE STRING SORT

USER

Value Expressions System Functions CREATE TABLE statement

User-defined function

User-defined functions

User-defined procedure

User-defined procedures

USING

Position Expression Length Expression Substring Function SELECT statement

Using SQL

- V -

Value Expressions

About Value Expressions

Boolean Value Expressions

Case Expressions

Cast Specification

DateTime Value Expressions

Numeric Value Expressions

Row Value Expressions

String Value Expressions

Subquieries

VALUES

Row Value Expressions INSERT statement

VARCHAR

variable length

VARYING

VIEW

CREATE VIEW statement

DROP ALIAS statement

DROP VIEW statement

View Dictionary

View Log

Visual Style

Introduction Global Options

- W -

WHEN

Case Expressions CREATE TRIGGER statement

WHERE

SELECT statement UPDATE statement DELETE statement

WHILE

WHILE statement

WIDTH

WITH

WITH DATA

WORD

WORK

COMMIT statement ROLLBACK statement

- Y -

YEAR

Year-Month Literal