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.
Keyword |
Res. |
Conformance |
Keyword |
Res. |
Conformance |
A |
|||||
ABS |
Y |
SQL:2003 |
ADD |
SQL:2003 |
|
AFTER |
SQL:2003 |
ALL |
Y |
SQL:2003 |
|
ALTER |
Y |
SQL:2003 |
AND |
Y |
SQL:2003 |
ANY |
Y |
SQL:2003 |
AS |
Y |
SQL:2003 |
ASC |
SQL:2003 |
ASSEMBLY |
Y |
NexusDB ext |
|
ASSERT |
Y |
NexusDB ext |
ATAN |
Y |
NexusDB ext |
ATAN2 |
Y |
NexusDB ext |
ATN2 |
Y |
NexusDB ext |
ATOMIC |
Y |
SQL:2003 |
AUTHORIZATION |
Y |
SQL:2003 |
AUTOINC |
Y |
NexusDB ext |
AVG |
Y |
SQL:2003 |
ALIAS |
Y |
NexusDB ext |
|
|
|
B |
|||||
BEFORE |
SQL:2003 |
BEGIN |
Y |
SQL:2003 |
|
BETWEEN |
Y |
SQL:2003 |
BIGINT |
Y |
SQL:2003 |
BINARY |
Y |
SQL:2003 |
BLOB |
Y |
SQL:2003 |
BLOCK |
NexusDB ext |
BLOCKSIZE |
NexusDB ext |
||
BOOL |
Y |
NexusDB ext |
BOOLEAN |
Y |
SQL:2003 |
BOTH |
Y |
SQL:2003 |
BROUND |
Y |
NexusDB ext |
BY |
Y |
SQL:2003 |
BYTE |
Y |
NexusDB ext |
BYTEARRAY |
Y |
NexusDB ext |
|||
C |
|||||
CALL |
Y |
SQL:2003 |
CALLED |
Y |
SQL:2003 |
CASCADE |
SQL:2003 |
CASE |
Y |
SQL:2003 |
|
CAST |
Y |
SQL:2003 |
CATCH |
Y |
NexusDB ext |
CEIL |
Y |
SQL:2003 |
CEILING |
Y |
SQL:2003 |
CHAR |
Y |
SQL:2003 |
CHAR_LENGTH |
Y |
SQL:2003 |
CHARACTER |
Y |
SQL:2003 |
CHARACTER_LENGTH |
Y |
SQL:2003 |
CHARACTERS |
SQL:2003 |
CHECK |
Y |
SQL:2003 |
|
CHR |
Y |
NexusDB ext |
CLOB |
Y |
SQL:2003 |
CLR |
NexusDB ext |
COALESCE |
Y |
SQL:2003 |
|
CODEPAGE |
NexusDB ext |
COLLATE |
Y |
SQL:2003 |
|
COLLATION |
SQL:2003 |
COLUMN |
Y |
SQL:2003 |
|
COMMIT |
Y |
SQL:2003 |
CONSTRAINT |
Y |
SQL:2003 |
CONTAINS |
SQL:2003 |
COS |
Y |
NexusDB ext |
|
COUNT |
Y |
SQL:2003 |
CREATE |
Y |
SQL:2003 |
CROSS |
Y |
SQL:2003 |
CURRENT_DATE |
Y |
SQL:2003 |
CURRENT_TIME |
Y |
SQL:2003 |
CURRENT_TIMESTAMP |
Y |
SQL:2003 |
CURRENT_USER |
Y |
SQL:2003 |
|||
D |
|||||
DATA |
SQL:2003 |
DATE |
Y |
SQL:2003 |
|
DATETIME |
Y |
NexusDB ext |
DAY |
Y |
SQL:2003 |
DEC |
Y |
SQL:2003 |
DECIMAL |
Y |
SQL:2003 |
DECLARE |
Y |
SQL:2003 |
DEFAULT |
Y |
SQL:2003 |
DELETE |
Y |
SQL:2003 |
DELETING |
Y |
NexusDB ext |
DESC |
SQL:2003 |
DESCRIPTION |
NexusDB ext |
||
DETERMINISTIC |
Y |
SQL:2003 |
DISTINCT |
Y |
SQL:2003 |
DO |
Y |
SQL:2003 |
DOUBLE |
Y |
SQL:2003 |
DROP |
Y |
SQL:2003 |
DWORD |
Y |
NexusDB ext |
E |
|||||
EACH |
Y |
SQL:2003 |
ELSE |
Y |
SQL:2003 |
ELSEIF |
Y |
NexusDB ext |
EMPTY |
Y |
NexusDB ext |
ENCRYPT |
NexusDB ext |
ENCRYPTION |
NexusDB ext |
||
END |
Y |
SQL:2003 |
ENGINE |
NexusDB ext |
|
EQUIVALENT |
Y |
NexusDB ext |
ERROR_MESSAGE |
Y |
NexusDB ext |
ESCAPE |
Y |
SQL:2003 |
EXCEPT |
Y |
SQL:2003 |
EXISTS |
Y |
SQL:2003 |
EXP |
Y |
SQL:2003 |
EXTENDED |
Y |
NexusDB ext |
EXTERNAL |
Y |
SQL:2003 |
EXTRACT |
Y |
SQL:2003 |
|||
F |
|||||
FALSE |
Y |
SQL:2003 |
FIRST |
SQL:2003 |
|
FLOAT |
Y |
SQL:2003 |
FLOOR |
Y |
SQL:2003 |
FOR |
Y |
SQL:2003 |
FOREIGN |
Y |
SQL:2003 |
FROM |
Y |
SQL:2003 |
FULL |
Y |
SQL:2003 |
FUNCTION |
Y |
SQL:2003 |
|||
G |
|||||
GLOBAL |
Y |
SQL:2003 |
GROUP |
Y |
SQL:2003 |
GROW |
NexusDB ext |
GROWSIZE |
NexusDB ext |
||
GUID |
Y |
NexusDB ext |
|||
H |
|||||
HAVING |
Y |
SQL:2003 |
HOUR |
Y |
SQL:2003 |
I |
|||||
IDENTITY |
Y |
SQL:2003 |
IF |
Y |
SQL:2003 |
IGNORE |
Y |
NexusDB ext |
IMAGE |
Y |
NexusDB ext |
IN |
Y |
SQL:2003 |
INDEX |
Y |
NexusDB ext |
INITIAL |
NexusDB ext |
INITIALSIZE |
NexusDB ext |
||
INNER |
Y |
SQL:2003 |
INOUT |
Y |
SQL:2003 |
INPUT |
SQL:2003 |
INSERT |
Y |
SQL:2003 |
|
INSERTING |
Y |
NexusDB ext |
INT |
Y |
SQL:2003 |
INTEGER |
Y |
SQL:2003 |
INTERSECT |
Y |
SQL:2003 |
INTERVAL |
Y |
SQL:2003 |
INTO |
Y |
SQL:2003 |
IS |
Y |
SQL:2003 |
ITERATE |
Y |
SQL:2003 |
J |
|||||
JOIN |
Y |
SQL:2003 |
|||
K |
|||||
KANA |
NexusDB ext |
KEY |
SQL:2003 |
||
L |
|||||
LANGUAGE |
Y |
SQL:2003 |
LARGE |
Y |
SQL:2003 |
LARGEINT |
Y |
NexusDB ext |
LAST |
SQL:2003 |
|
LASTAUTOINC |
Y |
NexusDB ext |
LEADING |
Y |
SQL:2003 |
LEAVE |
Y |
SQL:2003 |
LEFT |
Y |
SQL:2003 |
LIKE |
Y |
SQL:2003 |
LIST |
Y |
NexusDB ext |
LN |
Y |
SQL:2003 |
LOCAL |
Y |
SQL:2003 |
LOCALE |
Y |
NexusDB ext |
LOCALTIME |
Y |
SQL:2003 |
LOCALTIMESTAMP |
Y |
SQL:2003 |
LOWER |
Y |
SQL:2003 |
M |
|||||
MATCH |
Y |
SQL:2003 |
MAX |
Y |
SQL:2003 |
MED |
Y |
NexusDB ext |
MIN |
Y |
SQL:2003 |
MINUTE |
Y |
SQL:2003 |
MOD |
Y |
SQL:2003 |
MODIFIES |
Y |
SQL:2003 |
MONEY |
Y |
NexusDB ext |
MONTH |
Y |
SQL:2003 |
|||
N |
|||||
NAME |
SQL:2003 |
NATIONAL |
Y |
SQL:2003 |
|
NATURAL |
Y |
SQL:2003 |
NCHAR |
Y |
SQL:2003 |
NCLOB |
Y |
SQL:2003 |
NEW |
Y |
SQL:2003 |
NEWGUID |
Y |
NexusDB ext |
NO |
Y |
SQL:2003 |
NONSPACE |
NexusDB ext |
NOT |
Y |
SQL:2003 |
|
NSINGLECHAR |
Y |
NexusDB ext |
NULL |
Y |
SQL:2003 |
NULLIF |
Y |
SQL:2003 |
NULLS |
SQL:2003 |
|
NULLSTRING |
Y |
NexusDB ext |
NUMERIC |
Y |
SQL:2003 |
NVARCHAR |
Y |
NexusDB ext |
|||
O |
|||||
OBJECT |
SQL:2003 |
OCTET_LENGTH |
Y |
SQL:2003 |
|
OCTETS |
SQL:2003 |
ODD |
Y |
NexusDB ext |
|
OF |
Y |
SQL:2003 |
OLD |
Y |
SQL:2003 |
ON |
Y |
SQL:2003 |
OR |
Y |
SQL:2003 |
ORD |
Y |
NexusDB ext |
ORDER |
Y |
SQL:2003 |
OUT |
Y |
SQL:2003 |
OUTER |
Y |
SQL:2003 |
P |
|||||
PARTIAL |
SQL:2003 |
PASSWORDS |
Y |
NexusDB ext |
|
PERCENT |
NexusDB ext |
PI |
Y |
NexusDB ext |
|
POSITION |
Y |
SQL:2003 |
POWER |
Y |
SQL:2003 |
PRECISION |
Y |
SQL:2003 |
PRIMARY |
Y |
SQL:2003 |
PROCEDURE |
Y |
SQL:2003 |
PATH |
Y |
NexusDB ext |
R |
|||||
RAND |
Y |
NexusDB ext |
READS |
Y |
SQL:2003 |
REAL |
Y |
SQL:2003 |
RECREV |
Y |
NexusDB ext |
REFERENCES |
Y |
SQL:2003 |
REFERENCING |
Y |
SQL:2003 |
REMOVE |
NexusDB ext |
REPEAT |
Y |
SQL:2003 |
|
RESTRICT |
SQL:2003 |
RETURN |
Y |
SQL:2003 |
|
RETURNS |
Y |
SQL:2003 |
RIGHT |
Y |
SQL:2003 |
ROLLBACK |
Y |
SQL:2003 |
ROUND |
Y |
NexusDB ext |
ROUTINE |
SQL:2003 |
ROW |
Y |
SQL:2003 |
|
ROWSAFFECTED |
Y |
NexusDB ext |
ROWSREAD |
Y |
NexusDB ext |
S |
|||||
SECOND |
Y |
SQL:2003 |
SELECT |
Y |
SQL:2003 |
SERIALIZABLE |
SQL:2003 |
SESSION_USER |
Y |
SQL:2003 |
|
SET |
Y |
SQL:2003 |
SHORTINT |
Y |
NexusDB ext |
SHORTSTRING |
Y |
NexusDB ext |
SIGNAL |
Y |
SQL:2003 |
SIMPLE |
SQL:2003 |
SIN |
Y |
NexusDB ext |
|
SINGLECHAR |
Y |
NexusDB ext |
SMALLINT |
Y |
SQL:2003 |
SNAPSHOT |
NexusDB ext |
SOME |
Y |
SQL:2003 |
|
SORT |
NexusDB ext |
SQL |
Y |
SQL:2003 |
|
SQRT |
Y |
SQL:2003 |
START |
Y |
SQL:2003 |
STD |
Y |
NexusDB ext |
STORAGE |
NexusDB ext |
|
STRING |
NexusDB ext |
SUBSTRING |
Y |
SQL:2003 |
|
SUM |
Y |
SQL:2003 |
SYMBOLS |
NexusDB ext |
|
SYSTEM_ROW# |
Y |
NexusDB ext |
|||
T |
|||||
TABLE |
Y |
SQL:2003 |
TEMPORARY |
SQL:2003 |
|
TEXT |
Y |
NexusDB ext |
THEN |
Y |
SQL:2003 |
TIME |
Y |
SQL:2003 |
TIMESTAMP |
Y |
SQL:2003 |
TINYINT |
Y |
NexusDB ext |
TO |
Y |
SQL:2003 |
TOP |
NexusDB ext |
TOSTRING |
Y |
NexusDB ext |
|
TOSTRINGLEN |
Y |
NexusDB ext |
TRAILING |
Y |
SQL:2003 |
TRANSACTION |
SQL:2003 |
TRIGGER |
Y |
SQL:2003 |
|
TRIM |
Y |
SQL:2003 |
TRUE |
Y |
SQL:2003 |
TRY |
Y |
NexusDB ext |
TYPE |
SQL:2003 |
|
U |
|||||
UNION |
Y |
SQL:2003 |
UNIQUE |
Y |
SQL:2003 |
UNKNOWN |
Y |
SQL:2003 |
UNTIL |
Y |
SQL:2003 |
UPDATE |
Y |
SQL:2003 |
UPDATING |
Y |
NexusDB ext |
UPPER |
Y |
SQL:2003 |
USE |
NexusDB ext |
|
USER |
Y |
SQL:2003 |
USING |
Y |
SQL:2003 |
V |
|||||
VALUES |
Y |
SQL:2003 |
VARCHAR |
Y |
SQL:2003 |
VARYING |
Y |
SQL:2003 |
VIEW |
SQL:2003 |
|
W |
|||||
WHEN |
Y |
SQL:2003 |
WHERE |
Y |
SQL:2003 |
WHILE |
Y |
SQL:2003 |
WIDTH |
NexusDB ext |
|
WITH |
Y |
SQL:2003 |
WORD |
Y |
NexusDB ext |
WORK |
SQL:2003 |
||||
Y |
|||||
YEAR |
Y |
SQL:2003 |