Melt Grammar Rules
sql_list
: sql ';'
| sql_list sql ';'
sql
: schema_element_list
| view_def
| manipulative_statement
| routine_declaration
| trigger_def
| drop_trigger
schema_element_list
: schema_element
| schema_element_list schema_element
schema_element
: base_table_def
| create_index_def
| drop_table
| drop_index
| add_column
| table_rename
| privilege_def
| privilege_revoke
| create_user_statement
| delete_user_statement
| set_pass
| set_group_stmt
base_table_def
: CREATE TABLE new_table_name '(' base_table_element_commalist ')'
base_table_element_commalist
: base_table_element
| base_table_element_commalist ',' base_table_element
base_table_element
: column_def
| table_constraint_def
column_def
: column data_type column_def_opt_list
column_def_opt_list
: /* empty */
| column_def_opt_list column_def_opt
column_def_opt
: NOT NULLX
| IDENTITY
| NOT NULLX PRIMARY KEY opt_index_option_list
| DEFAULT literal
| references
table_constraint_def
: UNDER q_table_name
| PRIMARY KEY '(' index_column_commalist ')' opt_index_option_list
| FOREIGN KEY '(' column_commalist ')' references
column_commalist
: column
| column_commalist ',' column
index_column_commalist
: column opt_asc_desc
| index_column_commalist ',' column opt_asc_desc
opt_index_option_list
: /* empty */
| index_option_list
create_index_def
: CREATE opt_index_option_list INDEX index ON new_table_name '(' index_column_commalist ')'
drop_index
: DROP INDEX NAME opt_table
opt_table
: /* empty */
| q_table_name
drop_table
: DROP TABLE q_table_name
add_column
: ALTER TABLE q_table_name ADD opt_col_add_column add_col_column_def_list
| ALTER TABLE q_table_name DROP opt_col_add_column add_col_column_list
| ALTER TABLE q_table_name MODIFY opt_col_add_column column_def
table_rename
: ALTER TABLE q_table_name RENAME new_table_name
view_def
: CREATE VIEW new_table_name opt_column_commalist AS query_exp opt_with_check_option
opt_with_check_option
: /* empty */
| WITH CHECK OPTION
opt_column_commalist
: /* empty */
| '(' column_commalist ')'
privilege_def
: GRANT ALL PRIVILEGES TO grantee
| GRANT privileges ON table TO grantee_commalist opt_with_grant_option
| GRANT grantee_commalist TO grantee_commalist opt_with_admin_option
privilege_revoke
: REVOKE ALL PRIVILEGES FROM grantee_commalist
| REVOKE privileges ON table FROM grantee_commalist
| REVOKE grantee_commalist FROM grantee_commalist
opt_with_grant_option
: /* empty */
| WITH GRANT OPTION
opt_with_admin_option
: /* empty */
| WITH ADMIN OPTION
privileges
: ALL PRIVILEGES
| ALL
| operation_commalist
operation_commalist
: operation
| operation_commalist ',' operation
operation
: SELECT priv_opt_column_commalist
| INSERT
| DELETE
| UPDATE priv_opt_column_commalist
| EXECUTE
grantee_commalist
: grantee
| grantee_commalist ',' grantee
grantee
: PUBLIC
| user
set_pass
: SET PASSWORD NAME NAME
create_user_statement
: CREATE USER user
| CREATE ROLE user
delete_user_statement
: DELETE USER user [CASCADE]
| DROP ROLE user
set_group_stmt
: SET USER GROUP user user
opt_asc_desc
: /* empty */
| ASC
| DESC
manipulative_statement
: query_exp
| update_statement_positioned
| update_statement_searched
| insert_statement
| delete_statement_positioned
| delete_statement_searched
| call_statement
| admin_statement
| use_statement
use_statement
: USE NAME
delete_statement_positioned
: DELETE FROM table WHERE CURRENT OF cursor
delete_statement_searched
: DELETE FROM table opt_where_clause
insert_statement
: INSERT insert_mode table priv_opt_column_commalist values_or_query_spec
values_or_query_spec
: VALUES '(' insert_atom_commalist ')'
| query_spec
insert_atom_commalist
: insert_atom
| insert_atom_commalist ',' insert_atom
insert_atom
: scalar_exp
update_statement_positioned
: UPDATE table SET assignment_commalist WHERE CURRENT OF cursor
assignment_commalist
: /* empty */
| assignment
| assignment_commalist ',' assignment
assignment
: column COMPARISON scalar_exp
update_statement_searched
: UPDATE table SET assignment_commalist opt_where_clause
opt_where_clause
: /* empty */
| where_clause
query_exp
: query_term
| query_exp UNION query_term
| query_exp UNION ALL query_term
query_term
: query_spec
| '(' query_exp ')'
query_spec
: SELECT opt_all_distinct selection table_exp
selection
: scalar_exp_commalist
table_exp
: from_clause opt_where_clause opt_group_by_clause opt_having_clause opt_order_by_clause opt_lock_mode
from_clause
: FROM table_ref_commalist
table_ref_commalist
: table_ref
| table_ref_commalist ',' table_ref
table_ref
: table
| '(' query_exp ')' NAME
| joined_table
joined_table
: table_ref jtype opt_outer JOIN table_ref_nj ON search_condition
| BEGIN_OJ_X table_ref jtype opt_outer JOIN table_ref_nj ON search_condition ENDX
where_clause
: WHERE search_condition
opt_group_by_clause
: /* empty */
| GROUP BY ordering_spec_commalist
opt_having_clause
: /* empty */
| HAVING search_condition
opt_lock_mode
: /* empty */
| FOR UPDATE
search_condition
: /* empty */
| search_condition OR search_condition
| search_condition AND search_condition
| NOT search_condition
| '(' search_condition ')'
| predicate
predicate
: comparison_predicate
| between_predicate
| like_predicate
| test_for_null
| in_predicate
| all_or_any_predicate
| existence_test
| scalar_exp_predicate
scalar_exp_predicate
: scalar_exp
comparison_predicate
: scalar_exp COMPARISON scalar_exp
| scalar_exp COMPARISON subquery
between_predicate
: scalar_exp NOT BETWEEN scalar_exp AND scalar_exp
| scalar_exp BETWEEN scalar_exp AND scalar_exp
like_predicate
: scalar_exp NOT LIKE scalar_exp opt_escape
| scalar_exp LIKE scalar_exp opt_escape
opt_escape
: /* empty */
| ESCAPE atom
| BEGINX ESCAPE atom ENDX
test_for_null
: column_ref IS NOT NULLX
| column_ref IS NULLX
in_predicate
: scalar_exp NOT IN subquery
| scalar_exp IN subquery
| scalar_exp NOT IN '(' scalar_exp_commalist ')'
| scalar_exp IN '(' scalar_exp_commalist ')'
all_or_any_predicate
: scalar_exp COMPARISON any_all_some subquery
any_all_some
: ANY
| ALL
| SOME
existence_test
: EXISTS subquery
subquery
: '(' SELECT opt_all_distinct selection table_exp ')'
scalar_exp
: scalar_exp '+' scalar_exp
| scalar_exp '-' scalar_exp
| scalar_exp '*' scalar_exp
| scalar_exp '/' scalar_exp
| '+' scalar_exp %prec UMINUS
| '-' scalar_exp %prec UMINUS
| atom
| column_ref
| function_ref
| '(' scalar_exp ')'
| '(' scalar_exp ',' scalar_exp_commalist ')'
| function_call
| as_expression
| assignment_statement
| cvt_exp
cvt_exp
: CONVERT '(' data_type ',' scalar_exp ')'
as_expression
: scalar_exp AS NAME data_type
| scalar_exp AS NAME
function_call
: q_table_name '(' opt_scalar_exp_commalist ')'
| BEGIN_FN_X NAME '(' opt_scalar_exp_commalist ')' ENDX
| BEGIN_FN_X USER '(' opt_scalar_exp_commalist ')' ENDX
| BEGIN_FN_X CHARACTER '(' opt_scalar_exp_commalist ')' ENDX
| CALL '(' scalar_exp ')' '(' opt_scalar_exp_commalist ')'
scalar_exp_commalist
: scalar_exp
| scalar_exp_commalist ',' scalar_exp
atom
: parameter_ref
| literal
| USER
| obe_literal
parameter_ref
: parameter
| parameter parameter
| parameter INDICATOR parameter
function_ref
: AMMSC '(' '*' ')'
| AMMSC '(' DISTINCT scalar_exp ')'
| AMMSC '(' ALL scalar_exp ')'
| AMMSC '(' scalar_exp ')'
literal
: STRING
| INTNUM
| APPROXNUM
| NULLX
q_table_name
: NAME
| NAME '.' NAME
| NAME '.' NAME '.' NAME
| NAME '.' '.' NAME
new_table_name
: NAME
| NAME '.' NAME
| NAME '.' NAME '.' NAME
| NAME '.' '.' NAME
table
: q_table_name
| q_table_name AS NAME
| q_table_name NAME
column_ref
: NAME
| NAME '.' NAME
| NAME '.' NAME '.' NAME
| NAME '.' NAME '.' NAME '.' NAME
| NAME '.' '.' NAME '.' NAME
| '*'
| NAME '.' '*'
| NAME '.' NAME '.' '*'
| NAME '.' NAME '.' NAME '.' '*'
| NAME '.' '.' NAME '.' '*'
data_type
: CHARACTER
| VARCHAR
| VARCHAR '(' INTNUM ')'
| CHARACTER '(' INTNUM ')'
| NUMERIC
| NUMERIC '(' INTNUM ')'
| NUMERIC '(' INTNUM ',' INTNUM ')'
| DECIMAL
| DECIMAL '(' INTNUM ')'
| DECIMAL '(' INTNUM ',' INTNUM ')'
| INTEGER
| SMALLINT
| FLOAT
| FLOAT '(' INTNUM ')'
| REAL
| DOUBLE PRECISION
| LONG VARCHAR
| LONG VARBINARY
| TIMESTAMP
| DATETIME
| TIME
| DATE
| OWNER
column
: NAME
index
: NAME
cursor
: NAME
parameter
: PARAMETER
user
: NAME
admin_statement
: CHECKPOINT opt_log
| SHUTDOWN opt_log
| SET REPLICATION atom
| LOG OFF
| LOG ON
routine_declaration
: CREATE routine_head new_table_name rout_parameter_list opt_return compound_statement
routine_head
: FUNCTION
| PROCEDURE
opt_return
: /* empty */
| RETURNS data_type
rout_parameter_list
: '(' parameter_commalist ')'
parameter_commalist
: rout_parameter
| parameter_commalist ',' rout_parameter
rout_parameter
: parameter_mode column_ref data_type
parameter_mode
: IN
| OUT
| INOUT
compound_statement
: BEGINX statement_list ENDX
statement_list
: statement_in_cs
| statement_list statement_in_cs
statement_in_cs
: local_declaration ';'
| compound_statement
| routine_statement ';'
| control_statement
| NAME ':' statement
statement
: routine_statement ';'
| control_statement
| compound_statement
local_declaration
: cursor_def
| variable_declaration
| handler_declaration
variable_declaration
: DECLARE variable_list data_type
variable_list
: NAME
| variable_list ',' NAME
handler_declaration
: WHENEVER condition GOTO NAME
| WHENEVER condition GO TO NAME
control_statement
: call_statement ';'
| return_statement ';'
| assignment_statement ';'
| if_statement
| goto_statement ';'
| while_statement
assignment_statement
: lvalue EQUALS scalar_exp
lvalue
: column_ref
if_statement
: IF '(' search_condition ')' statement opt_else
opt_else
: /* empty */
| ELSE statement
call_statement
: CALL q_table_name '(' opt_scalar_exp_commalist ')'
| function_call
goto_statement
: GOTO NAME
| GO TO NAME
return_statement
: RETURN scalar_exp
| RETURN
while_statement
: WHILE '(' search_condition ')' statement
trigger_def
: CREATE TRIGGER NAME action_time event ON q_table_name opt_old_ref compound_statement
action_time
: BEFORE
| AFTER
event
: INSERT
| UPDATE
| DELETE
opt_old_ref
: /* empty */
| REFERENCING old_commalist
old_commalist
: old_alias
| old_commalist ',' old_alias
old_alias
: OLD AS NAME
| NEW AS NAME
drop_trigger
: DROP TRIGGER q_table_name
references
: REFERENCES q_table_name opt_column_commalist
index_option_list
: index_option
| index_option_list index_option
add_col_column_def_list
: column_def
| add_col_column_def_list ',' column_def
add_col_column_list
: column
| add_col_column_list ',' column
priv_opt_column_commalist
: /* empty */
| '(' column_commalist ')'
cursor_def
: DECLARE NAME CURSOR FOR query_spec
opt_order_by_clause
: /* empty */
| ORDER BY ordering_spec_commalist
ordering_spec_commalist
: ordering_spec
| ordering_spec_commalist ',' ordering_spec
ordering_spec
: INTNUM opt_asc_desc
| column_ref opt_asc_desc
| function_ref opt_asc_desc
insert_mode
: INTO
| REPLACING
| SOFT
opt_all_distinct
: /* empty */
| ALL
| DISTINCT
table_ref_nj
: table
| subquery NAME
opt_outer
: /* empty */
| OUTER
jtype
: LEFT
opt_scalar_exp_commalist
: /* empty */
| scalar_exp_commalist
obe_literal
: BEGINX NAME atom ENDX
opt_log
: /* empty */
| scalar_exp
routine_statement
: select_statement
| update_statement_positioned
| update_statement_searched
| insert_statement
| delete_statement_positioned
| delete_statement_searched
| close_statement
| fetch_statement
| open_statement
| commit_statement
| ';'
condition
: NOT FOUND
| SQLSTATE STRING
index_option
: CLUSTERED
| UNIQUE
close_statement
: CLOSE cursor
fetch_statement
: FETCH cursor INTO target_commalist
open_statement
: OPEN cursor opt_cursor_options_list
select_statement
: SELECT opt_all_distinct selection table_exp
| SELECT opt_all_distinct selection INTO target_commalist table_exp with_opt_cursor_options_list
target_commalist
: target
| target_commalist ',' target
target
: column_ref
opt_cursor_options_list
: /* empty */
| '(' cursor_options_commalist ')'
with_opt_cursor_options_list
: /* empty */
| WITH opt_cursor_options_list
cursor_options_commalist
: cursor_option
| cursor_options_commalist ',' cursor_option
cursor_option
: EXCLUSIVE
| PREFETCH INTNUM
'Used-In' Rules
/* is used in these productions:
assignment_commalist
column_def_opt_list
opt_all_distinct
opt_asc_desc
opt_column_commalist
opt_cursor_options_list
opt_else
opt_escape
opt_group_by_clause
opt_having_clause
opt_index_option_list
opt_lock_mode
opt_log
opt_old_ref
opt_order_by_clause
opt_outer
opt_return
opt_scalar_exp_commalist
opt_table
opt_where_clause
opt_with_admin_option
opt_with_check_option
opt_with_grant_option
priv_opt_column_commalist
search_condition
with_opt_cursor_options_list
',' is used in these productions:
add_col_column_def_list
add_col_column_list
assignment_commalist
base_table_element_commalist
column_commalist
cursor_options_commalist
cvt_exp
data_type
grantee_commalist
index_column_commalist
insert_atom_commalist
old_commalist
operation_commalist
ordering_spec_commalist
parameter_commalist
scalar_exp
scalar_exp_commalist
table_ref_commalist
target_commalist
variable_list
';' is used in these productions:
control_statement
routine_statement
sql_list
statement
statement_in_cs
':' is used in these productions:
statement_in_cs
'/' is used in these productions:
scalar_exp
'.' is used in these productions:
column_ref
new_table_name
q_table_name
'-' is used in these productions:
scalar_exp
'(' is used in these productions:
base_table_def
call_statement
create_index_def
cvt_exp
data_type
function_call
function_ref
if_statement
in_predicate
opt_column_commalist
opt_cursor_options_list
priv_opt_column_commalist
query_term
rout_parameter_list
scalar_exp
search_condition
subquery
table_constraint_def
table_ref
values_or_query_spec
while_statement
')' is used in these productions:
base_table_def
call_statement
create_index_def
cvt_exp
data_type
function_call
function_ref
if_statement
in_predicate
opt_column_commalist
opt_cursor_options_list
priv_opt_column_commalist
query_term
rout_parameter_list
scalar_exp
search_condition
subquery
table_constraint_def
table_ref
values_or_query_spec
while_statement
'*' is used in these productions:
column_ref
function_ref
scalar_exp
'+' is used in these productions:
scalar_exp
[CASCADE] is used in these productions:
delete_user_statement
*/ is used in these productions:
assignment_commalist
column_def_opt_list
opt_all_distinct
opt_asc_desc
opt_column_commalist
opt_cursor_options_list
opt_else
opt_escape
opt_group_by_clause
opt_having_clause
opt_index_option_list
opt_lock_mode
opt_log
opt_old_ref
opt_order_by_clause
opt_outer
opt_return
opt_scalar_exp_commalist
opt_table
opt_where_clause
opt_with_admin_option
opt_with_check_option
opt_with_grant_option
priv_opt_column_commalist
search_condition
with_opt_cursor_options_list
%prec is used in these productions:
scalar_exp
ADD is used in these productions:
add_column
ADMIN is used in these productions:
opt_with_admin_option
AFTER is used in these productions:
action_time
ALL is used in these productions:
any_all_some
function_ref
opt_all_distinct
privilege_def
privilege_revoke
privileges
query_exp
ALTER is used in these productions:
add_column
table_rename
AMMSC is used in these productions:
function_ref
AND is used in these productions:
between_predicate
search_condition
ANY is used in these productions:
any_all_some
APPROXNUM is used in these productions:
literal
AS is used in these productions:
as_expression
old_alias
table
view_def
ASC is used in these productions:
opt_asc_desc
BEFORE is used in these productions:
action_time
BEGIN_FN_X is used in these productions:
function_call
BEGIN_OJ_X is used in these productions:
joined_table
BEGINX is used in these productions:
compound_statement
obe_literal
opt_escape
BETWEEN is used in these productions:
between_predicate
BY is used in these productions:
opt_group_by_clause
opt_order_by_clause
CALL is used in these productions:
call_statement
function_call
CHARACTER is used in these productions:
data_type
function_call
CHECK is used in these productions:
opt_with_check_option
CHECKPOINT is used in these productions:
admin_statement
CLOSE is used in these productions:
close_statement
CLUSTERED is used in these productions:
index_option
commit_statement is used in these productions:
routine_statement
COMPARISON is used in these productions:
all_or_any_predicate
assignment
comparison_predicate
CONVERT is used in these productions:
cvt_exp
CREATE is used in these productions:
base_table_def
create_index_def
create_user_statement
routine_declaration
trigger_def
view_def
CURRENT is used in these productions:
delete_statement_positioned
update_statement_positioned
CURSOR is used in these productions:
cursor_def
DATE is used in these productions:
data_type
DATETIME is used in these productions:
data_type
DECIMAL is used in these productions:
data_type
DECLARE is used in these productions:
cursor_def
variable_declaration
DEFAULT is used in these productions:
column_def_opt
DELETE is used in these productions:
delete_statement_positioned
delete_statement_searched
delete_user_statement
event
operation
DESC is used in these productions:
opt_asc_desc
DISTINCT is used in these productions:
function_ref
opt_all_distinct
DOUBLE is used in these productions:
data_type
DROP is used in these productions:
add_column
delete_user_statement
drop_index
drop_table
drop_trigger
ELSE is used in these productions:
opt_else
empty is used in these productions:
assignment_commalist
column_def_opt_list
opt_all_distinct
opt_asc_desc
opt_column_commalist
opt_cursor_options_list
opt_else
opt_escape
opt_group_by_clause
opt_having_clause
opt_index_option_list
opt_lock_mode
opt_log
opt_old_ref
opt_order_by_clause
opt_outer
opt_return
opt_scalar_exp_commalist
opt_table
opt_where_clause
opt_with_admin_option
opt_with_check_option
opt_with_grant_option
priv_opt_column_commalist
search_condition
with_opt_cursor_options_list
ENDX is used in these productions:
compound_statement
function_call
joined_table
obe_literal
opt_escape
EQUALS is used in these productions:
assignment_statement
ESCAPE is used in these productions:
opt_escape
EXCLUSIVE is used in these productions:
cursor_option
EXECUTE is used in these productions:
operation
EXISTS is used in these productions:
existence_test
FETCH is used in these productions:
fetch_statement
FLOAT is used in these productions:
data_type
FOR is used in these productions:
cursor_def
opt_lock_mode
FOREIGN is used in these productions:
table_constraint_def
FOUND is used in these productions:
condition
FROM is used in these productions:
delete_statement_positioned
delete_statement_searched
from_clause
privilege_revoke
FUNCTION is used in these productions:
routine_head
GO is used in these productions:
goto_statement
handler_declaration
GOTO is used in these productions:
goto_statement
handler_declaration
GRANT is used in these productions:
opt_with_grant_option
privilege_def
GROUP is used in these productions:
opt_group_by_clause
set_group_stmt
HAVING is used in these productions:
opt_having_clause
IDENTITY is used in these productions:
column_def_opt
IF is used in these productions:
if_statement
IN is used in these productions:
in_predicate
parameter_mode
INDEX is used in these productions:
create_index_def
drop_index
INDICATOR is used in these productions:
parameter_ref
INOUT is used in these productions:
parameter_mode
INSERT is used in these productions:
event
insert_statement
operation
INTEGER is used in these productions:
data_type
INTNUM is used in these productions:
cursor_option
data_type
literal
ordering_spec
INTO is used in these productions:
fetch_statement
insert_mode
select_statement
IS is used in these productions:
test_for_null
JOIN is used in these productions:
joined_table
KEY is used in these productions:
column_def_opt
table_constraint_def
LEFT is used in these productions:
jtype
LIKE is used in these productions:
like_predicate
LOG is used in these productions:
admin_statement
LONG is used in these productions:
data_type
MODIFY is used in these productions:
add_column
NAME is used in these productions:
as_expression
column
column_ref
cursor
cursor_def
drop_index
function_call
goto_statement
handler_declaration
index
new_table_name
obe_literal
old_alias
q_table_name
set_pass
statement_in_cs
table
table_ref
table_ref_nj
trigger_def
use_statement
user
variable_list
NEW is used in these productions:
old_alias
NOT is used in these productions:
between_predicate
column_def_opt
condition
in_predicate
like_predicate
search_condition
test_for_null
NULLX is used in these productions:
column_def_opt
literal
test_for_null
NUMERIC is used in these productions:
data_type
OF is used in these productions:
delete_statement_positioned
update_statement_positioned
OFF is used in these productions:
admin_statement
OLD is used in these productions:
old_alias
ON is used in these productions:
admin_statement
create_index_def
joined_table
privilege_def
privilege_revoke
trigger_def
OPEN is used in these productions:
open_statement
opt_col_add_column is used in these productions:
add_column
OPTION is used in these productions:
opt_with_admin_option
opt_with_check_option
opt_with_grant_option
OR is used in these productions:
search_condition
ORDER is used in these productions:
opt_order_by_clause
OUT is used in these productions:
parameter_mode
OUTER is used in these productions:
opt_outer
OWNER is used in these productions:
data_type
PARAMETER is used in these productions:
parameter
PASSWORD is used in these productions:
set_pass
PRECISION is used in these productions:
data_type
PREFETCH is used in these productions:
cursor_option
PRIMARY is used in these productions:
column_def_opt
table_constraint_def
PRIVILEGES is used in these productions:
privilege_def
privilege_revoke
privileges
PROCEDURE is used in these productions:
routine_head
PUBLIC is used in these productions:
grantee
REAL is used in these productions:
data_type
REFERENCES is used in these productions:
references
REFERENCING is used in these productions:
opt_old_ref
RENAME is used in these productions:
table_rename
REPLACING is used in these productions:
insert_mode
REPLICATION is used in these productions:
admin_statement
RETURN is used in these productions:
return_statement
RETURNS is used in these productions:
opt_return
REVOKE is used in these productions:
privilege_revoke
ROLE is used in these productions:
create_user_statement
delete_user_statement
SELECT is used in these productions:
operation
query_spec
select_statement
subquery
SET is used in these productions:
admin_statement
set_group_stmt
set_pass
update_statement_positioned
update_statement_searched
SHUTDOWN is used in these productions:
admin_statement
SMALLINT is used in these productions:
data_type
SOFT is used in these productions:
insert_mode
SOME is used in these productions:
any_all_some
SQLSTATE is used in these productions:
condition
STRING is used in these productions:
condition
literal
TABLE is used in these productions:
add_column
base_table_def
drop_table
table_rename
TIME is used in these productions:
data_type
TIMESTAMP is used in these productions:
data_type
TO is used in these productions:
goto_statement
handler_declaration
privilege_def
TRIGGER is used in these productions:
drop_trigger
trigger_def
UMINUS is used in these productions:
scalar_exp
UNDER is used in these productions:
table_constraint_def
UNION is used in these productions:
query_exp
UNIQUE is used in these productions:
index_option
UPDATE is used in these productions:
event
operation
opt_lock_mode
update_statement_positioned
update_statement_searched
USE is used in these productions:
use_statement
USER is used in these productions:
atom
create_user_statement
delete_user_statement
function_call
set_group_stmt
VALUES is used in these productions:
values_or_query_spec
VARBINARY is used in these productions:
data_type
VARCHAR is used in these productions:
data_type
VIEW is used in these productions:
view_def
WHENEVER is used in these productions:
handler_declaration
WHERE is used in these productions:
delete_statement_positioned
update_statement_positioned
where_clause
WHILE is used in these productions:
while_statement
WITH is used in these productions:
opt_with_admin_option
opt_with_check_option
opt_with_grant_option
with_opt_cursor_options_list
action_time is used in these productions:
trigger_def
add_col_column_def_list is used in these productions:
add_col_column_def_list
add_column
add_col_column_list is used in these productions:
add_col_column_list
add_column
add_column is used in these productions:
schema_element
admin_statement is used in these productions:
manipulative_statement
all_or_any_predicate is used in these productions:
predicate
any_all_some is used in these productions:
all_or_any_predicate
as_expression is used in these productions:
scalar_exp
assignment is used in these productions:
assignment_commalist
assignment_commalist is used in these productions:
assignment_commalist
update_statement_positioned
update_statement_searched
assignment_statement is used in these productions:
control_statement
scalar_exp
atom is used in these productions:
admin_statement
obe_literal
opt_escape
scalar_exp
base_table_def is used in these productions:
schema_element
base_table_element is used in these productions:
base_table_element_commalist
base_table_element_commalist is used in these productions:
base_table_def
base_table_element_commalist
between_predicate is used in these productions:
predicate
call_statement is used in these productions:
control_statement
manipulative_statement
close_statement is used in these productions:
routine_statement
column is used in these productions:
add_col_column_list
assignment
column_commalist
column_def
index_column_commalist
column_commalist is used in these productions:
column_commalist
opt_column_commalist
priv_opt_column_commalist
table_constraint_def
column_def is used in these productions:
add_col_column_def_list
add_column
base_table_element
column_def_opt is used in these productions:
column_def_opt_list
column_def_opt_list is used in these productions:
column_def
column_def_opt_list
column_ref is used in these productions:
lvalue
ordering_spec
rout_parameter
scalar_exp
target
test_for_null
comparison_predicate is used in these productions:
predicate
compound_statement is used in these productions:
routine_declaration
statement
statement_in_cs
trigger_def
condition is used in these productions:
handler_declaration
control_statement is used in these productions:
statement
statement_in_cs
create_index_def is used in these productions:
schema_element
create_user_statement is used in these productions:
schema_element
cursor is used in these productions:
close_statement
delete_statement_positioned
fetch_statement
open_statement
update_statement_positioned
cursor_def is used in these productions:
local_declaration
cursor_option is used in these productions:
cursor_options_commalist
cursor_options_commalist is used in these productions:
cursor_options_commalist
opt_cursor_options_list
cvt_exp is used in these productions:
scalar_exp
data_type is used in these productions:
as_expression
column_def
cvt_exp
opt_return
rout_parameter
variable_declaration
delete_statement_positioned is used in these productions:
manipulative_statement
routine_statement
delete_statement_searched is used in these productions:
manipulative_statement
routine_statement
delete_user_statement is used in these productions:
schema_element
drop_index is used in these productions:
schema_element
drop_table is used in these productions:
schema_element
drop_trigger is used in these productions:
sql
event is used in these productions:
trigger_def
existence_test is used in these productions:
predicate
fetch_statement is used in these productions:
routine_statement
from_clause is used in these productions:
table_exp
function_call is used in these productions:
call_statement
scalar_exp
function_ref is used in these productions:
ordering_spec
scalar_exp
goto_statement is used in these productions:
control_statement
grantee is used in these productions:
grantee_commalist
privilege_def
grantee_commalist is used in these productions:
grantee_commalist
privilege_def
privilege_revoke
handler_declaration is used in these productions:
local_declaration
if_statement is used in these productions:
control_statement
in_predicate is used in these productions:
predicate
index is used in these productions:
create_index_def
index_column_commalist is used in these productions:
create_index_def
index_column_commalist
table_constraint_def
index_option is used in these productions:
index_option_list
index_option_list is used in these productions:
index_option_list
opt_index_option_list
insert_atom is used in these productions:
insert_atom_commalist
insert_atom_commalist is used in these productions:
insert_atom_commalist
values_or_query_spec
insert_mode is used in these productions:
insert_statement
insert_statement is used in these productions:
manipulative_statement
routine_statement
joined_table is used in these productions:
table_ref
jtype is used in these productions:
joined_table
like_predicate is used in these productions:
predicate
literal is used in these productions:
atom
column_def_opt
local_declaration is used in these productions:
statement_in_cs
lvalue is used in these productions:
assignment_statement
manipulative_statement is used in these productions:
sql
new_table_name is used in these productions:
base_table_def
create_index_def
routine_declaration
table_rename
view_def
obe_literal is used in these productions:
atom
old_alias is used in these productions:
old_commalist
old_commalist is used in these productions:
old_commalist
opt_old_ref
open_statement is used in these productions:
routine_statement
operation is used in these productions:
operation_commalist
operation_commalist is used in these productions:
operation_commalist
privileges
opt_all_distinct is used in these productions:
query_spec
select_statement
subquery
opt_asc_desc is used in these productions:
index_column_commalist
ordering_spec
opt_column_commalist is used in these productions:
references
view_def
opt_cursor_options_list is used in these productions:
open_statement
with_opt_cursor_options_list
opt_else is used in these productions:
if_statement
opt_escape is used in these productions:
like_predicate
opt_group_by_clause is used in these productions:
table_exp
opt_having_clause is used in these productions:
table_exp
opt_index_option_list is used in these productions:
column_def_opt
create_index_def
table_constraint_def
opt_lock_mode is used in these productions:
table_exp
opt_log is used in these productions:
admin_statement
opt_old_ref is used in these productions:
trigger_def
opt_order_by_clause is used in these productions:
table_exp
opt_outer is used in these productions:
joined_table
opt_return is used in these productions:
routine_declaration
opt_scalar_exp_commalist is used in these productions:
call_statement
function_call
opt_table is used in these productions:
drop_index
opt_where_clause is used in these productions:
delete_statement_searched
table_exp
update_statement_searched
opt_with_admin_option is used in these productions:
privilege_def
opt_with_check_option is used in these productions:
view_def
opt_with_grant_option is used in these productions:
privilege_def
ordering_spec is used in these productions:
ordering_spec_commalist
ordering_spec_commalist is used in these productions:
opt_group_by_clause
opt_order_by_clause
ordering_spec_commalist
parameter is used in these productions:
parameter_ref
parameter_commalist is used in these productions:
parameter_commalist
rout_parameter_list
parameter_mode is used in these productions:
rout_parameter
parameter_ref is used in these productions:
atom
predicate is used in these productions:
search_condition
priv_opt_column_commalist is used in these productions:
insert_statement
operation
privilege_def is used in these productions:
schema_element
privilege_revoke is used in these productions:
schema_element
privileges is used in these productions:
privilege_def
privilege_revoke
q_table_name is used in these productions:
add_column
call_statement
drop_table
drop_trigger
function_call
opt_table
references
table
table_constraint_def
table_rename
trigger_def
query_exp is used in these productions:
manipulative_statement
query_exp
query_term
table_ref
view_def
query_spec is used in these productions:
cursor_def
query_term
values_or_query_spec
query_term is used in these productions:
query_exp
references is used in these productions:
column_def_opt
table_constraint_def
return_statement is used in these productions:
control_statement
rout_parameter is used in these productions:
parameter_commalist
rout_parameter_list is used in these productions:
routine_declaration
routine_declaration is used in these productions:
sql
routine_head is used in these productions:
routine_declaration
routine_statement is used in these productions:
statement
statement_in_cs
scalar_exp is used in these productions:
all_or_any_predicate
as_expression
assignment
assignment_statement
between_predicate
comparison_predicate
cvt_exp
function_call
function_ref
in_predicate
insert_atom
like_predicate
opt_log
return_statement
scalar_exp
scalar_exp_commalist
scalar_exp_predicate
scalar_exp_commalist is used in these productions:
in_predicate
opt_scalar_exp_commalist
scalar_exp
scalar_exp_commalist
selection
scalar_exp_predicate is used in these productions:
predicate
schema_element is used in these productions:
schema_element_list
schema_element_list is used in these productions:
schema_element_list
sql
search_condition is used in these productions:
if_statement
joined_table
opt_having_clause
search_condition
where_clause
while_statement
select_statement is used in these productions:
routine_statement
selection is used in these productions:
query_spec
select_statement
subquery
set_group_stmt is used in these productions:
schema_element
set_pass is used in these productions:
schema_element
sql is used in these productions:
sql_list
sql_list is used in these productions:
sql_list
statement is used in these productions:
if_statement
opt_else
statement_in_cs
while_statement
statement_in_cs is used in these productions:
statement_list
statement_list is used in these productions:
compound_statement
statement_list
subquery is used in these productions:
all_or_any_predicate
comparison_predicate
existence_test
in_predicate
table_ref_nj
table is used in these productions:
delete_statement_positioned
delete_statement_searched
insert_statement
privilege_def
privilege_revoke
table_ref
table_ref_nj
update_statement_positioned
update_statement_searched
table_constraint_def is used in these productions:
base_table_element
table_exp is used in these productions:
query_spec
select_statement
subquery
table_ref is used in these productions:
joined_table
table_ref_commalist
table_ref_commalist is used in these productions:
from_clause
table_ref_commalist
table_ref_nj is used in these productions:
joined_table
table_rename is used in these productions:
schema_element
target is used in these productions:
target_commalist
target_commalist is used in these productions:
fetch_statement
select_statement
target_commalist
test_for_null is used in these productions:
predicate
trigger_def is used in these productions:
sql
update_statement_positioned is used in these productions:
manipulative_statement
routine_statement
update_statement_searched is used in these productions:
manipulative_statement
routine_statement
use_statement is used in these productions:
manipulative_statement
user is used in these productions:
create_user_statement
delete_user_statement
grantee
set_group_stmt
values_or_query_spec is used in these productions:
insert_statement
variable_declaration is used in these productions:
local_declaration
variable_list is used in these productions:
variable_declaration
variable_list
view_def is used in these productions:
sql
where_clause is used in these productions:
opt_where_clause
while_statement is used in these productions:
control_statement
with_opt_cursor_options_list is used in these productions:
select_statement
Valid XHTML 1.0! Valid CSS!

The views and opinions expressed in this page are strictly those of the page author.
The contents of this page have not been reviewed or approved by the University of Minnesota.