NexusDB V3 SQL extends the SQL grammar of V2. The new features and changes from V2 are detailed below.

New features in V3
Alias management:

CREATE ALIAS statement

DROP ALIAS statement

ALTER ALIAS statement

SQL Cursor support:

DECLARE CURSOR statement

OPEN statement

CLOSE statement

FETCH statement

Dynamic SQL:

EXECUTE statement

SQL Extension Scripting:

CREATE ASSEMBLY statement extension

Changes from V2
Keywords:

ALIAS is now a keyword

PATH is now a keyword

While there have been massive changes and extensions to the internals of the SQL engine, we've kept V3 compatible to V2. So there are no more significant changes (except fixes) to V2 functionality.


Core SQL:2003 Features

Additional SQL:2003 Features

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference