|

|

|

|

<SQL schema statement>

<SQL data statement>

<SQL control statement>

<SQL transaction statement>

<SQL session statement>

|

<SQL schema definition statement>

<SQL schema manipulation statement>

|

|

|

|

<table definition>

<index definition>

<view definition>

<SQL-invoked routine>

<trigger definition>

|

|

|

|

|

<alter table statement>

<drop table statement>

<drop index statement>

<drop view statement>

<drop routine statement>

<drop trigger statement>

|

<select statement>

<SQL data change statement>

|

|

<insert statement>

<update statement: searched>

<delete statement: searched>

|

|

|

|

|

|

|

|

|

|

|

<call statement>

<return statement>

<compound statement>

<SQL variable declaration>

<assignment statement>

<if statement>

<iterate statement>

<leave statement>

<repeat statement>

<while statement>

<signal statement>

<try statement>

|

|

<start transaction statement>

<commit statement>

<rollback statement>

<set passwords statement>

SQL:2003 standard

NexusDB extensions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Core SQL

Feature T651 "SQL-schema statements in SQL routines"

Feature P002-01 "Compound statement"

Feature P002-04 "SQL variable declaration"

Feature P002-05 "Assignment statement"

Feature P002-07 "IF statement"

Feature P002-08 "ITERATE statement"

Feature P002-09 "LEAVE statement"

Feature P002-11 "REPEAT statement"

Feature P002-12 "WHILE statement"

Feature P002-14 "SIGNAL statement"

CREATE INDEX statement

DROP INDEX statement

TRY statement

SET PASSWORDS statement