Syntaxis ODBC SQL opdrachten

Syntaxisbeschrijving in Backus-Naur notatie.

create-table-statement ::=
     CREATE TABLE base-table-name
     (column-identifier data-type [,column-identifier data-type]…)

delete-statement-searched ::=
     DELETE FROM table-name [WHERE search-condition]

drop-table-statement ::=
     DROP TABLE base-table-name

insert-statement ::=
     INSERT INTO table-name [( column-identifier [, column-identifier]...)]
     VALUES (insert-value[, insert-value]... )

select-statement ::=
     SELECT [ALL | DISTINCT] select-list
     FROM table-reference-list
     [WHERE search-condition]
     [order-by-clause]

statement ::= create-table-statement
     | delete-statement-searched
     | drop-table-statement
     | insert-statement
     | select-statement
     | update-statement-searched

update-statement-searched
     UPDATE table-name
     SET column-identifier = {expression | NULL }
          [, column-identifier = {expression | NULL}]...
     [WHERE search-condition]