This page describes the full CockroachDB SQL grammar. However, as a starting point, it's best to reference our SQL statements pages first, which provide detailed explanations and examples.
no references
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_split_index_stmt
- alter_split_stmt
- create_table_as_stmt
- create_view_stmt
- export_stmt
- insert_rest
- preparable_stmt
- stmt
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_user_password_stmt
- backup_stmt
- create_role_stmt
- create_user_stmt
- export_stmt
- import_stmt
- kv_option
- opt_password
- show_backup_stmt
- string_or_placeholder_list
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_rename_table_stmt
- alter_scatter_stmt
- alter_split_stmt
- col_qualification_elem
- constraint_elem
- copy_from_stmt
- create_index_stmt
- create_stats_stmt
- create_table_as_stmt
- create_table_stmt
- import_stmt
- insert_target
- opt_interleave
- relation_expr
- scrub_table_stmt
- show_columns_stmt
- show_constraints_stmt
- show_create_table_stmt
- show_indexes_stmt
- show_ranges_stmt
- show_stats_stmt
- sortby
- table_name_list
- table_name_with_index
- view_name
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- column_name
- column_path
- column_path_with_star
- complex_db_object_name
- complex_table_pattern
- constraint_name
- database_name
- deallocate_stmt
- family_name
- kv_option
- name_list
- opt_existing_window_name
- opt_name
- opt_name_parens
- prefixed_column_path
- privilege
- savepoint_name
- savepoint_stmt
- show_schemas_stmt
- show_tables_stmt
- simple_db_object_name
- statistics_name
- table_alias_name
- var_name
- window_name
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- constraint_elem
- create_stats_stmt
- family_def
- for_grantee_clause
- grant_stmt
- join_qual
- opt_column_list
- opt_conf_expr
- opt_interleave
- opt_storing
- partition_by
- revoke_stmt
- scrub_option
- targets
- targets_roles
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- a_expr
- alter_column_default
- alter_table_cmd
- array_subscript
- cancel_job_stmt
- cancel_query_stmt
- cancel_session_stmt
- case_arg
- case_default
- col_qualification_elem
- constraint_elem
- d_expr
- expr_list
- extract_list
- filter_clause
- func_expr_common_subexpr
- having_clause
- implicit_row
- join_qual
- offset_clause
- opt_select_fetch_first_value
- opt_slice_bound
- overlay_list
- overlay_placing
- pause_stmt
- resume_stmt
- select_limit_value
- single_set_clause
- sortby
- substr_for
- substr_from
- substr_list
- target_elem
- trim_list
- var_value
- when_clause
- where_clause
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_table_cmd
- drop_database_stmt
- drop_index_stmt
- drop_sequence_stmt
- drop_table_stmt
- drop_view_stmt
- truncate_stmt
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- opt_encoding_clause
- opt_lc_collate_clause
- opt_lc_ctype_clause
- opt_template_clause
- string_or_placeholder
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_onetable_stmt
- alter_rename_sequence_stmt
- alter_rename_table_stmt
- alter_rename_view_stmt
- relation_expr_list
- relation_expr_opt_alias
- table_ref
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_scatter_index_stmt
- alter_scatter_stmt
- distinct_on_clause
- execute_param_clause
- extract_list
- func_application
- func_expr_common_subexpr
- group_clause
- implicit_row
- in_expr
- list_partition
- opt_expr_list
- opt_partition_clause
- overlay_list
- range_partition
- special_function
- trim_list
- values_clause
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_rename_sequence_stmt
- alter_sequence_options_stmt
- create_sequence_stmt
- show_create_sequence_stmt
referenced by:
referenced by:
referenced by:
referenced by:
- alter_oneindex_stmt
- alter_rename_index_stmt
- alter_scatter_index_stmt
- alter_split_index_stmt
- show_ranges_stmt
- table_name_with_index_list
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- attrs
- collation_name
- column_path_with_star
- complex_db_object_name
- complex_table_pattern
- index_name
- partition_name
- prefixed_column_path
- target_name
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_rename_index_stmt
- create_index_stmt
- index_hints_param
- opt_index_hints
- sortby
- table_name_with_index
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
generated by Railroad Diagram Generator