BNF Index of SQL2
index on key words
index on special characters
[other languages BNF]
distinct syntax trees in the SQL2 language
SQL2 which may be directly invoked
direct_sql_stmt
Lexical rules
token
separator
Module language
module
Dynamic commands
prep_stmt
Embedded SQL languages
embdd_sql_host_program
embdd_sql_declare_section
embdd_sql_stmt
embdd_exception_decl
abbreviation used in rule's names
author authorization
char character
dec declaration
def defined
def definition
diag diagnostics
dyn dynamic
embdd embedded
exec executable
exp expression
fct function
frac fractional
id identifier
implt implementation
lit literal
num numeric
op operator
pos positionned
ref referential
rep repertoire
spec specification
std standard
stmt statement
univ universal
index of rules
- action
- action_list
- actual_id
- ada_assignment_op
- ada_host_id
- ada_initial_value
- ada_qualified_type_spec
- ada_type_spec
- ada_unqualified_type_spec
- ada_variable_def
- add_column_def
- add_domain_constraint_def
- add_table_constraint_def
- all
- allocate_cursor_stmt
- allocate_descriptor_stmt
- alter_column_action
- alter_column_def
- alter_domain_action
- alter_domain_stmt
- alter_table_action
- alter_table_stmt
- ampersand
- approximate_num_lit
- approximate_num_type
- arc1
- arc2
- arc3
- argument
- assertion_check
- assertion_def
- asterisk
- as_clause
- between_predicate
- bit
- bit_concatenation
- bit_factor
- bit_length_exp
- bit_primary
- bit_string_lit
- bit_string_type
- bit_substring_fct
- bit_value_exp
- bit_value_fct
- boolean_factor
- boolean_primary
- boolean_term
- boolean_test
- case_abbreviation
- case_exp
- case_operand
- case_spec
- cast_operand
- cast_spec
- cast_target
- catalog_name
- char_factor
- char_length_exp
- char_primary
- char_representation
- char_set_def
- char_set_name
- char_set_source
- char_set_spec
- char_string_lit
- char_string_type
- char_substring_fct
- char_translation
- char_value_exp
- char_value_fct
- check_constraint_def
- close_stmt
- cobol_binary_integer
- cobol_bit_type
- cobol_char_type
- cobol_computational_int
- cobol_host_id
- cobol_integer_type
- cobol_nines
- cobol_nines_spec
- cobol_num_type
- cobol_type_spec
- cobol_variable_def
- collate_clause
- collating_sequence_def
- collation_def
- collation_name
- collation_source
- colon
- column_constraint
- column_constraint_def
- column_def
- column_name
- column_name_list
- column_ref
- comma
- comment
- comment_char
- comment_introducer
- commit_stmt
- comp_op
- comp_predicate
- concatenation
- condition
- condition_action
- condition_information
- condition_information_item
- condition_info_item_name
- condition_number
- connection_name
- connection_object
- connection_target
- connect_stmt
- constraint_attributes
- constraint_check_time
- constraint_name
- constraint_name_def
- constraint_name_list
- correlation_name
- corresponding_column_list
- corresponding_spec
- cross_join
- currenttimestamp_value_fct
- current_date_value_fct
- current_time_value_fct
- cursor_name
- cursor_spec
- c_array_spec
- c_bit_variable
- c_char_variable
- c_class_modifier
- c_derived_variable
- c_host_id
- c_initial_value
- c_num_variable
- c_storage_class
- c_varchar_variable
- c_variable_def
- c_variable_spec
- data_type
- datetime_factor
- datetime_field
- datetime_lit
- datetime_primary
- datetime_term
- datetime_type
- datetime_value
- datetime_value_exp
- datetime_value_fct
- date_lit
- date_string
- date_value
- days_value
- deallocate_descriptor_stmt
- deallocate_prepared_stmt
- declare_cursor
- default_clause
- default_option
- default_spec
- delete_rule
- delete_stmt_pos
- delete_stmt_searched
- delimited_id
- delimited_id_body
- delimited_id_part
- delimiter_token
- derived_column
- derived_column_list
- derived_table
- describe_input_stmt
- describe_output_stmt
- describe_stmt
- descriptor_item_name
- descriptor_name
- diag_size
- digit
- directly_exec_stmt
- direct_implt_def_stmt
- direct_select_stmt_n_rows
- direct_sql_data_stmt
- direct_sql_stmt
- disconnect_object
- disconnect_stmt
- domain_constraint
- domain_def
- domain_name
- doublequote_symbol
- double_quote
- drop_assertion_stmt
- drop_behavior
- drop_char_set_stmt
- drop_collation_stmt
- drop_column_def
- drop_column_default_clause
- drop_domain_constraint_def
- drop_domain_default_clause
- drop_domain_stmt
- drop_schema_stmt
- drop_table_constraint_def
- drop_table_stmt
- drop_translation_stmt
- drop_view_stmt
- dyn_close_stmt
- dyn_cursor_name
- dyn_declare_cursor
- dyn_delete_stmt_pos
- dyn_fetch_stmt
- dyn_open_stmt
- dyn_parameter_spec
- dyn_select_stmt
- dyn_single_row_select_stmt
- dyn_update_stmt_pos
- e1987
- e1989
- e1989_base
- e1989_package
- e1992
- else_clause
- embdd_char_set_decl
- embdd_exception_decl
- embdd_sql_ada_program
- embdd_sql_begin_declare
- embdd_sql_cobol_program
- embdd_sql_c_program
- embdd_sql_declare_section
- embdd_sql_end_declare
- embdd_sql_fortran_program
- embdd_sql_host_program
- embdd_sql_mumps_declare
- embdd_sql_mumps_program
- embdd_sql_pascal_program
- embdd_sql_pl1_program
- embdd_sql_stmt
- embdd_variable_name
- end_field
- equals_op
- escape_char
- exact_num_lit
- exact_num_type
- execute_immediate_stmt
- execute_stmt
- existing_char_set_name
- exists_predicate
- explicit_table
- exponent
- extended_cursor_name
- extended_stmt_name
- external_collation
- external_collation_name
- external_translation
- external_translation_name
- extract_exp
- extract_field
- extract_source
- factor
- fetch_orientation
- fetch_stmt
- fetch_target_list
- fold
- form_conversion
- form_conversion_name
- fortran_host_id
- fortran_type_spec
- fortran_variable_def
- from_clause
- general_lit
- general_set_fct
- general_value_spec
- get_count
- get_descriptor_information
- get_descriptor_stmt
- get_diag_stmt
- get_item_information
- goto_target
- go_to
- grantee
- grant_stmt
- greater_than_op
- grouping_column_ref
- grouping_column_ref_list
- group_by_clause
- having_clause
- hexit
- hex_string_lit
- high
- host_id
- host_label_id
- host_pl1_label_variable
- host_variable_def
- hours_value
- id
- id_body
- id_part
- id_start
- implt_def_char_rep_name
- implt_def_collation_name
- implt_def_translation_name
- implt_def_univ_char_name
- indicator_parameter
- indicator_variable
- insert_columns_and_source
- insert_column_list
- insert_stmt
- integrity_no
- integrity_yes
- intermediate
- interval_factor
- interval_frac_seconds_prec
- interval_leading_fieldprec
- interval_lit
- interval_primary
- interval_qualifier
- interval_term
- interval_term_1
- interval_term_2
- interval_type
- interval_value_exp
- interval_value_exp_1
- introducer
- in_predicate
- in_predicate_value
- in_value_list
- isolation_level
- item_number
- joined_table
- join_column_list
- join_condition
- join_spec
- join_type
- key_word
- left_bracket
- left_paren
- length
- length_exp
- less_than_op
- levels_clause
- level_of_isolation
- like_predicate
- limited_collation_def
- lit
- local_table_name
- low
- mantissa
- match_predicate
- match_type
- match_value
- minus_sign
- minutes_value
- module_contents
- months_value
- mumps_char_variable
- mumps_host_id
- mumps_length_spec
- mumps_num_variable
- mumps_type_spec
- mumps_variable_def
- named_columns_join
- national_char_string_lit
- national_char_string_type
- newline
- next_in_c_list
- nondelimiter_token
- nondoublequote_char
- nonquote_char
- non_join_query_exp
- non_join_query_primary
- non_join_query_term
- non_reserved_word
- non_second_datetime_field
- null_predicate
- null_spec
- number_of_conditions
- num_primary
- num_type
- num_value_exp
- num_value_fct
- object_column
- object_name
- occurrences
- octet_length_exp
- open_stmt
- ordering_spec
- order_by_clause
- outer_join_type
- overlaps_predicate
- pad_attribute
- parameter_decl
- parameter_decl_list
- parameter_name
- parameter_spec
- parameter_using_clause
- pascal_host_id
- pascal_type_spec
- pascal_variable_def
- pattern
- percent
- period
- pl1_host_id
- pl1_type_fixed_binary
- pl1_type_fixed_decimal
- pl1_type_float_binary
- pl1_type_spec
- pl1_variable_def
- plus_sign
- position_exp
- precision
- predicate
- prepare_stmt
- prep_dyn_delete_stmt_pos
- prep_dyn_update_stmt_pos
- prep_implt_def_stmt
- prep_sql_data_stmt
- prep_sql_schema_stmt
- prep_sql_session_stmt
- prep_sql_transaction_stmt
- prep_stmt
- privileges
- privilege_column_list
- procedure
- procedure_name
- qualified_id
- qualified_join
- qualified_local_table_name
- qualified_name
- qualifier
- quantified_comp_predicate
- quantifier
- query_exp
- query_primary
- query_spec
- query_term
- question_mark
- quote
- quote_symbol
- refd_table_and_columns
- referencing_columns
- refs_spec
- ref_action
- ref_column_list
- ref_constraint_def
- ref_triggered_action
- regular_id
- reserved_word
- result
- result_exp
- result_using_clause
- revoke_stmt
- right_bracket
- right_paren
- rollback_stmt
- row_subquery
- row_value_constructor
- row_value_constructor_1
- row_value_constructor_2
- row_value_constructor_elem
- row_value_const_list
- scalar_subquery
- scale
- schema_author_id
- schema_char_set_name
- schema_char_set_spec
- schema_collation_name
- schema_def
- schema_element
- schema_name
- schema_name_clause
- schema_translation_name
- scope_option
- searched_case
- searched_when_clause
- search_condition
- seconds_integer_value
- seconds_value
- select_list
- select_stmt_single_row
- select_sublist
- select_target_list
- semicolon
- separator
- set_catalog_stmt
- set_clause
- set_clause_list
- set_column_default_clause
- set_connection_stmt
- set_constraints_mode_stmt
- set_count
- set_descriptor_information
- set_descriptor_stmt
- set_domain_default_clause
- set_fct_spec
- set_fct_type
- set_item_information
- set_local_time_zone_stmt
- set_names_stmt
- set_quantifier
- set_schema_stmt
- set_session_author_id_stmt
- set_time_zone_value
- set_transaction_stmt
- sign
- signed_integer
- signed_num_lit
- simple_case
- simple_latin_letter
- simple_latin_lower_letter
- simple_latin_upper_letter
- simple_table
- simple_target_spec
- simple_target_spec_1
- simple_target_spec_2
- simple_value_spec
- simple_value_spec_1
- simple_value_spec_2
- simple_when_clause
- single_datetime_field
- solidus
- some
- sort_key
- sort_spec
- sort_spec_list
- source_char_set_spec
- space
- sql_conformance
- sql_connection_stmt
- sql_data_change_stmt
- sql_data_stmt
- sql_diag_information
- sql_diag_stmt
- sql_dyn_data_stmt
- sql_dyn_stmt
- sql_edition
- sql_embdd_language_char
- sql_language_char
- sql_language_id
- sql_language_id_part
- sql_language_id_start
- sql_object_id
- sql_prefix
- sql_procedure_stmt
- sql_provenance
- sql_schema_def_stmt
- sql_schema_manipulat_stmt
- sql_schema_stmt
- sql_server_name
- sql_session_stmt
- sql_special_char
- sql_stmt_name
- sql_stmt_variable
- sql_terminal_char
- sql_terminator
- sql_transaction_stmt
- sql_variant
- start_field
- start_position
- status_parameter
- std_char_rep_name
- std_collation_name
- std_translation_name
- std_univ_char_form_name
- stmt_information
- stmt_information_item
- stmt_info_item_name
- stmt_name
- stmt_or_decl
- string_length
- string_value_exp
- string_value_fct
- subquery
- system_descriptor_stmt
- table_constraint
- table_constraint_def
- table_def
- table_element
- table_element_list
- table_exp
- table_name
- table_ref
- table_subquery
- table_value_constructor
- table_value_const_list
- target_char_set_spec
- target_spec
- temporary_table_decl
- term
- timestamp_lit
- timestamp_precision
- time_frac_seconds_prec
- time_lit
- time_precision
- time_string
- time_value
- time_zone
- time_zone_field
- time_zone_specifier
- token
- transaction_access_mode
- transaction_mode
- translation_collation
- translation_def
- translation_name
- translation_source
- translation_spec
- trim_char
- trim_fct
- trim_operands
- trim_source
- trim_spec
- truth_value
- underscore
- unique_column_list
- unique_constraint_def
- unique_predicate
- unique_spec
- unqualified_schema_name
- unsigned_integer
- unsigned_lit
- unsigned_num_lit
- unsigned_value_spec
- updatability_clause
- update_rule
- update_source
- update_stmt_pos
- update_stmt_searched
- user_def_char_rep_name
- user_name
- using_arguments
- using_clause
- using_descriptor
- value_exp
- value_exp_primary
- value_spec
- variable_spec
- vertical_bar
- view_column_list
- view_def
- when_operand
- where_clause
- years_value
Jacques Guyot | guyot@cui.unige.ch