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:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_split_index_stmt
- alter_split_stmt
- cancel_jobs_stmt
- cancel_queries_stmt
- cancel_sessions_stmt
- create_table_as_stmt
- create_view_stmt
- export_stmt
- insert_rest
- pause_stmt
- preparable_stmt
- resume_stmt
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_rename_table_stmt
- alter_scatter_stmt
- alter_split_stmt
- alter_zone_table_stmt
- col_qualification_elem
- comment_stmt
- constraint_elem
- copy_from_stmt
- create_index_stmt
- create_stats_target
- 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_stmt
- show_indexes_stmt
- show_ranges_stmt
- show_stats_stmt
- show_zone_stmt
- single_table_pattern_list
- sortby
- table_index_name
- table_name_expr_with_index
- table_name_list
- view_name
referenced by:
referenced by:
- alter_rename_database_stmt
- alter_zone_database_stmt
- comment_stmt
- create_database_stmt
- drop_database_stmt
- scrub_database_stmt
- show_zone_stmt
referenced by:
referenced by:
referenced by:
- alias_clause
- common_table_expr
- execute_stmt
- insert_target
- prepare_stmt
- table_name_expr_opt_alias_idx
referenced by:
referenced by:
- column_name
- column_path
- constraint_name
- database_name
- db_object_name_component
- deallocate_stmt
- family_name
- import_format
- kv_option
- name_list
- opt_existing_window_name
- opt_name
- opt_name_parens
- opt_using_gin_btree
- privilege
- savepoint_name
- savepoint_stmt
- show_schemas_stmt
- show_sequences_stmt
- show_tables_stmt
- statistics_name
- table_alias_name
- var_name
- window_name
referenced by:
referenced by:
- alter_user_password_stmt
- backup_stmt
- create_role_stmt
- create_user_stmt
- export_stmt
- import_stmt
- kv_option
- opt_changefeed_sink
- opt_password
- show_backup_stmt
- string_or_placeholder_list
referenced by:
referenced by:
referenced by:
referenced by:
- constraint_elem
- family_def
- for_grantee_clause
- grant_stmt
- join_qual
- labeled_row
- opt_column_list
- opt_conf_expr
- opt_interleave
- opt_stats_columns
- 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:
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:
table_name_expr_opt_alias_idx:
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:
- a_expr
- alter_column_default
- array_subscript
- as_of_clause
- cancel_jobs_stmt
- cancel_queries_stmt
- cancel_sessions_stmt
- case_arg
- case_default
- col_qualification_elem
- constraint_elem
- d_expr
- expr_list
- extract_list
- filter_clause
- frame_bound
- func_expr_common_subexpr
- having_clause
- index_elem
- join_qual
- offset_clause
- opt_alter_column_using
- 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
- tuple1_ambiguous_values
- tuple1_unambiguous_values
- 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:
- 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:
- alter_scatter_index_stmt
- alter_scatter_stmt
- distinct_on_clause
- execute_param_clause
- extract_list
- func_application
- func_expr_common_subexpr
- group_clause
- list_partition
- opt_expr_list
- opt_partition_clause
- overlay_list
- range_partition
- special_function
- trim_list
- tuple1_ambiguous_values
- tuple1_unambiguous_values
- values_clause
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:
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:
- alter_oneindex_stmt
- alter_rename_index_stmt
- alter_scatter_index_stmt
- alter_split_index_stmt
- alter_zone_index_stmt
- show_ranges_stmt
- show_zone_stmt
- table_index_name_list
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
- table_ref
referenced by:
referenced by:
referenced by:
referenced by:
- column_path_with_star
- complex_db_object_name
- complex_table_pattern
- prefixed_column_path
- simple_db_object_name
referenced by:
- attrs
- collation_name
- column_path_with_star
- complex_db_object_name
- complex_table_pattern
- d_expr
- index_name
- partition_name
- prefixed_column_path
- target_name
- zone_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:
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:
cockroachdb_extra_reserved_keyword:
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