A.6. Production Cross-Reference

add set option

alter options list

standard aggregate function

unsigned value expression primary

all in group

select sublist

alter

directly executable statement

alter column options

alter options

alter options list

alter column options , alter options

alter options

ddl statement

analytic aggregate function

unsigned value expression primary

array table

table primary

assignment statement

delimited statement

assignment statement operand

assignment statement , declare statement

between predicate

boolean primary

boolean primary

filter clause , boolean factor

branching statement

delimited statement

case expression

unsigned value expression primary

character

match predicate , text aggregate function , text table

column list

other constraints , create temporary table , foreign key , insert statement primary key , with list element

common value expression

between predicate , boolean primary , comparison predicate , sql exception , match predicate , like regex predicate , in predicate , text table , unsigned value expression primary

comparison predicate

boolean primary

boolean term

boolean value expression

boolean value expression

condition

compound statement

statement

other constraints

create table body

table element

create table body

create procedure

ddl statement

typed element list

array table , dynamic data statement

create foreign temp table

directly executable statement

option namespace

ddl statement

create table

ddl statement

create table body

create foreign temp table , create table

create temporary table

directly executable statement

create trigger

ddl statement , directly executable statement

condition

expression , having clause , if statement , qualified table , searched case expression , where clause , while statement

cross join

joined table

declare statement

delimited statement

delete statement

assignment statement operand , directly executable statement

delimited statement

statement

derived column

derived column list , object table , querystring function , text aggregate function , xml attributes , xml query , xml table

derived column list

json object , xml forest

drop option

alter options list

drop table

directly executable statement

dynamic data statement

data statement

raise error statement

delimited statement

sql exception

assignment statement operand , exception reference

exception reference

sql exception , raise statement

named parameter list

call statement

exists predicate

boolean primary

expression

standard aggregate function , assignment statement operand , case expression , derived column , dynamic data statement , raise error statement , named parameter list , expression list , function , object table column , ordered aggregate function , querystring function , return statement , searched case expression , select derived column , set clause list , sort key , unsigned value expression primary , xml table column , xml element , xml parse , xml serialize

expression list

callable statement , other constraints , function , group by clause , insert statement , call statement , window specification

fetch clause

limit clause

filter clause

function , unsigned value expression primary

for each row trigger action

alter , create trigger

foreign key

create table body

from clause

query

function

unsigned value expression primary

group by clause

query

having clause

query

identifier

alter , alter column options , alter options , array table , assignment statement , branching statement , callable statement , column list , compound statement , table element , create procedure , typed element list , create foreign temp table , option namespace , create table , create table body , create temporary table , create trigger , declare statement , delete statement , derived column , drop option , drop table , dynamic data statement , exception reference , named parameter list , foreign key , function , insert statement , into clause , loop statement , xml namespace element , object table column , object table , option clause , option pair , procedure parameter , procedure result column , query primary , select derived column , set clause list , statement , call statement , table subquery , temporary table element , text aggregate function , text table column , text table , table name , update statement , with list element , xml table column , xml element , xml serialize , xml table

if statement

statement

insert statement

assignment statement operand , directly executable statement

integer parameter

fetch clause , limit clause

unsigned integer

dynamic data statement , integer parameter , data type , text table column , text table , unsigned value expression primary

time interval

function

into clause

query

is null predicate

boolean primary

joined table

table primary , table reference

json object

function

limit clause

query expression body

loop statement

statement

match predicate

boolean primary

xml namespace element

xml namespaces

non numeric literal

option pair , value expression primary

non-reserved identifier

identifier , unsigned value expression primary

boolean factor

boolean term

object table column

object table

object table

table primary

comparison operator

comparison predicate , quantified comparison predicate

option clause

callable statement , delete statement , insert statement , query expression body , call statement , update statement

option pair

add set option , options clause

options clause

table element , create procedure , create table , create table body , procedure parameter , procedure result column

order by clause

function , ordered aggregate function , query expression body , text aggregate function , window specification

ordered aggregate function

unsigned value expression primary

data type

table element , create procedure , typed element list , declare statement , function , object table column , procedure parameter , procedure result column , temporary table element , text table column , xml table column

numeric value expression

common value expression

plus or minus

option pair , numeric value expression , value expression primary

primary key

create table body

procedure parameter

create procedure

procedure result column

create procedure

qualified table

joined table

query

query primary

query expression

alter , assignment statement operand , create table , insert statement , loop statement , subquery , table subquery , directly executable statement , with list element

query expression body

query expression , query primary

query primary

query term

querystring function

function

query term

query expression body

raise statement

delimited statement

like regex predicate

boolean primary

return statement

delimited statement

searched case expression

unsigned value expression primary

select clause

query

select derived column

select sublist

select sublist

select clause

set clause list

dynamic data statement , update statement

in predicate

boolean primary

sort key

sort specification

sort specification

order by clause

data statement

delimited statement

statement

alter , compound statement , create procedure , for each row trigger action , if statement , loop statement , procedure body definition , while statement

call statement

assignment statement , subquery , table subquery , directly executable statement

string

character , table element , option namespace , function , xml namespace element , non numeric literal , object table column , object table , procedure parameter , text table column , text table , xml table column , xml query , xml serialize , xml table

subquery

exists predicate , in predicate , quantified comparison predicate , unsigned value expression primary

quantified comparison predicate

boolean primary

table subquery

table primary

temporary table element

create temporary table

table primary

cross join , joined table

table reference

from clause , qualified table

text aggregate function

unsigned value expression primary

text table column

text table

text table

table primary

term

numeric value expression

star or slash

term

table name

table primary

unsigned numeric literal

option pair , value expression primary

unsigned value expression primary

value expression primary

update statement

assignment statement operand , directly executable statement

directly executable statement

data statement

value expression primary

array table , term

where clause

delete statement , query , update statement

while statement

statement

window specification

unsigned value expression primary

with list element

query expression

xml attributes

xml element

xml table column

xml table

xml element

function

xml forest

function

xml namespaces

xml element , xml forest , xml query , xml table

xml parse

function

xml query

function

xml serialize

function

xml table

table primary