NexusDB Guide > SQL Reference > SQL Language Elements

NexusDB V3 Manual

Keywords

NexusDB Manual V3 > SQL Reference > SQL Language Elements

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

nexus_logo