Keywords are words recognized by SQL to have a distinct meaning within the context in which they appear. Keywords are used in SQL statements to identify the statement itself, the SQL grammar that specifies processing actions and the SQL elements used by the statement.

 

The SQL language is case-insensitive. Therefore, keywords, identifiers and other names written in upper case, lower case or mixed case with the same spelling mean the same thing. Throughout this manual, keywords are written in upper case to distinguish keywords from identifiers.

 

Many SQL keywords are reserved words. Reserved words cannot be used as names for database objects such as tables, columns, views etc. unless the word is enclosed by double quotes. For example, "Date" is a valid column name, while Date would cause an exception.

 

 

Overview of keywords in NexusDB SQL

 

Keyword

 

Res.

Conformance

 

Keyword

 

Res.

 

Conformance

 

A

 

 

 

 

 

ABS

SQL:2003

ADD

 

SQL:2003

AFTER

 

SQL:2003

ALL

SQL:2003

ALTER

SQL:2003

AND

SQL:2003

ANY

SQL:2003

AS

SQL:2003

ASC

 

SQL:2003

ASSEMBLY

NexusDB ext

ASSERT

NexusDB ext

ATAN

NexusDB ext

ATAN2

NexusDB ext

ATN2

NexusDB ext

ATOMIC

SQL:2003

AUTHORIZATION

SQL:2003

AUTOINC

NexusDB ext

AVG

SQL:2003

B

 

 

 

 

 

BEFORE

 

SQL:2003

BEGIN

SQL:2003

BETWEEN

SQL:2003

BIGINT

SQL:2003

BINARY

SQL:2003

BLOB

SQL:2003

BLOCK

 

NexusDB ext

BLOCKSIZE

 

NexusDB ext

BOOL

NexusDB ext

BOOLEAN

SQL:2003

BOTH

SQL:2003

BROUND

NexusDB ext

BY

SQL:2003

BYTE

NexusDB ext

BYTEARRAY

NexusDB ext

 

 

 

C

 

 

 

 

 

CALL

SQL:2003

CALLED

SQL:2003

CASCADE

 

SQL:2003

CASE

SQL:2003

CAST

SQL:2003

CATCH

NexusDB ext

CEIL

SQL:2003

CEILING

SQL:2003

CHAR

SQL:2003

CHAR_LENGTH

SQL:2003

CHARACTER

SQL:2003

CHARACTER_LENGTH

SQL:2003

CHARACTERS

 

SQL:2003

CHECK

SQL:2003

CHR

NexusDB ext

CLOB

SQL:2003

CLR

 

NexusDB ext

COALESCE

SQL:2003

CODEPAGE

 

NexusDB ext

COLLATE

SQL:2003

COLLATION

 

SQL:2003

COLUMN

SQL:2003

COMMIT

SQL:2003

CONSTRAINT

SQL:2003

CONTAINS

 

SQL:2003

COS

NexusDB ext

COUNT

SQL:2003

CREATE

SQL:2003

CROSS

SQL:2003

CURRENT_DATE

SQL:2003

CURRENT_TIME

SQL:2003

CURRENT_TIMESTAMP

SQL:2003

CURRENT_USER

SQL:2003

 

 

 

D

 

 

 

 

 

DATA

 

SQL:2003

DATE

SQL:2003

DATETIME

NexusDB ext

DAY

SQL:2003

DEC

SQL:2003

DECIMAL

SQL:2003

DECLARE

SQL:2003

DEFAULT

SQL:2003

DELETE

SQL:2003

DELETING

NexusDB ext

DESC

 

SQL:2003

DESCRIPTION

 

NexusDB ext

DETERMINISTIC

SQL:2003

DISTINCT

SQL:2003

DO

SQL:2003

DOUBLE

SQL:2003

DROP

SQL:2003

DWORD

NexusDB ext

E

 

 

 

 

 

EACH

SQL:2003

ELSE

SQL:2003

ELSEIF

NexusDB ext

EMPTY

NexusDB ext

ENCRYPT

 

NexusDB ext

ENCRYPTION

 

NexusDB ext

END

SQL:2003

ENGINE

 

NexusDB ext

EQUIVALENT

NexusDB ext

ERROR_MESSAGE

NexusDB ext

ESCAPE

SQL:2003

EXCEPT

SQL:2003

EXISTS

SQL:2003

EXP

SQL:2003

EXTENDED

NexusDB ext

EXTERNAL

SQL:2003

EXTRACT

SQL:2003

 

 

 

F

 

 

 

 

 

FALSE

SQL:2003

FIRST

 

SQL:2003

FLOAT

SQL:2003

FLOOR

SQL:2003

FOR

SQL:2003

FOREIGN

SQL:2003

FROM

SQL:2003

FULL

SQL:2003

FUNCTION

SQL:2003

 

 

 

G

 

 

 

 

 

GLOBAL

SQL:2003

GROUP

SQL:2003

GROW

 

NexusDB ext

GROWSIZE

 

NexusDB ext

GUID

NexusDB ext

 

 

 

H

 

 

 

 

 

HAVING

SQL:2003

HOUR

SQL:2003

I

 

 

 

 

 

IDENTITY

SQL:2003

IF

SQL:2003

IGNORE

NexusDB ext

IMAGE

NexusDB ext

IN

SQL:2003

INDEX

NexusDB ext

INITIAL

 

NexusDB ext

INITIALSIZE

 

NexusDB ext

INNER

SQL:2003

INOUT

SQL:2003

INPUT

 

SQL:2003

INSERT

SQL:2003

INSERTING

NexusDB ext

INT

SQL:2003

INTEGER

SQL:2003

INTERSECT

SQL:2003

INTERVAL

SQL:2003

INTO

SQL:2003

IS

SQL:2003

ITERATE

SQL:2003

J

 

 

 

 

 

JOIN

SQL:2003

 

 

 

K

 

 

 

 

 

KANA

 

NexusDB ext

KEY

 

SQL:2003

L

 

 

 

 

 

LANGUAGE

SQL:2003

LARGE

SQL:2003

LARGEINT

NexusDB ext

LAST

 

SQL:2003

LASTAUTOINC

NexusDB ext

LEADING

SQL:2003

LEAVE

SQL:2003

LEFT

SQL:2003

LIKE

SQL:2003

LIST

NexusDB ext

LN

SQL:2003

LOCAL

SQL:2003

LOCALE

NexusDB ext

LOCALTIME

SQL:2003

LOCALTIMESTAMP

SQL:2003

LOWER

SQL:2003

M

 

 

 

 

 

MATCH

SQL:2003

MAX

SQL:2003

MED

NexusDB ext

MIN

SQL:2003

MINUTE

SQL:2003

MOD

SQL:2003

MODIFIES

SQL:2003

MONEY

NexusDB ext

MONTH

SQL:2003

 

 

 

N

 

 

 

 

 

NAME

 

SQL:2003

NATIONAL

SQL:2003

NATURAL

SQL:2003

NCHAR

SQL:2003

NCLOB

SQL:2003

NEW

SQL:2003

NEWGUID

NexusDB ext

NO

SQL:2003

NONSPACE

 

NexusDB ext

NOT

SQL:2003

NSINGLECHAR

NexusDB ext

NULL

SQL:2003

NULLIF

SQL:2003

NULLS

 

SQL:2003

NULLSTRING

NexusDB ext

NUMERIC

SQL:2003

NVARCHAR

NexusDB ext

 

 

 

O

 

 

 

 

 

OBJECT

 

SQL:2003

OCTET_LENGTH

SQL:2003

OCTETS

 

SQL:2003

ODD

NexusDB ext

OF

SQL:2003

OLD

SQL:2003

ON

SQL:2003

OR

SQL:2003

ORD

NexusDB ext

ORDER

SQL:2003

OUT

SQL:2003

OUTER

SQL:2003

P

 

 

 

 

 

PARTIAL

 

SQL:2003

PASSWORDS

NexusDB ext

PERCENT

 

NexusDB ext

PI

NexusDB ext

POSITION

SQL:2003

POWER

SQL:2003

PRECISION

SQL:2003

PRIMARY

SQL:2003

PROCEDURE

SQL:2003

 

 

 

R

 

 

 

 

 

RAND

NexusDB ext

READS

SQL:2003

REAL

SQL:2003

RECREV

NexusDB ext

REFERENCES

SQL:2003

REFERENCING

SQL:2003

REMOVE

 

NexusDB ext

REPEAT

SQL:2003

RESTRICT

 

SQL:2003

RETURN

SQL:2003

RETURNS

SQL:2003

RIGHT

SQL:2003

ROLLBACK

SQL:2003

ROUND

NexusDB ext

ROUTINE

 

SQL:2003

ROW

SQL:2003

ROWSAFFECTED

NexusDB ext

ROWSREAD

NexusDB ext

S

 

 

 

 

 

SECOND

SQL:2003

SELECT

SQL:2003

SERIALIZABLE

 

SQL:2003

SESSION_USER

SQL:2003

SET

SQL:2003

SHORTINT

NexusDB ext

SHORTSTRING

NexusDB ext

SIGNAL

SQL:2003

SIMPLE

 

SQL:2003

SIN

NexusDB ext

SINGLECHAR

NexusDB ext

SMALLINT

SQL:2003

SNAPSHOT

 

NexusDB ext

SOME

SQL:2003

SORT

 

NexusDB ext

SQL

SQL:2003

SQRT

SQL:2003

START

SQL:2003

STD

NexusDB ext

STORAGE

 

NexusDB ext

STRING

 

NexusDB ext

SUBSTRING

SQL:2003

SUM

SQL:2003

SYMBOLS

 

NexusDB ext

SYSTEM_ROW#

NexusDB ext

 

 

 

T

 

 

 

 

 

TABLE

SQL:2003

TEMPORARY

 

SQL:2003

TEXT

NexusDB ext

THEN

SQL:2003

TIME

SQL:2003

TIMESTAMP

SQL:2003

TINYINT

NexusDB ext

TO

SQL:2003

TOP

 

NexusDB ext

TOSTRING

NexusDB ext

TOSTRINGLEN

NexusDB ext

TRAILING

SQL:2003

TRANSACTION

 

SQL:2003

TRIGGER

SQL:2003

TRIM

SQL:2003

TRUE

SQL:2003

TRY

NexusDB ext

TYPE

 

SQL:2003

U

 

 

 

 

 

UNION

SQL:2003

UNIQUE

SQL:2003

UNKNOWN

SQL:2003

UNTIL

SQL:2003

UPDATE

SQL:2003

UPDATING

NexusDB ext

UPPER

SQL:2003

USE

 

NexusDB ext

USER

SQL:2003

USING

SQL:2003

V

 

 

 

 

 

VALUES

SQL:2003

VARCHAR

SQL:2003

VARYING

SQL:2003

VIEW

 

SQL:2003

W

 

 

 

 

 

WHEN

SQL:2003

WHERE

SQL:2003

WHILE

SQL:2003

WIDTH

 

NexusDB ext

WITH

SQL:2003

WORD

NexusDB ext

WORK

 

SQL:2003

 

 

 

Y

 

 

 

 

 

YEAR

SQL:2003