Navigator Systems Nexus SQL Database Server

Contents | Index

- - -

- (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