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:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_split_index_stmt
- alter_split_stmt
- alter_unsplit_index_stmt
- alter_unsplit_stmt
- cancel_jobs_stmt
- cancel_queries_stmt
- cancel_sessions_stmt
- create_table_as_stmt
- create_view_stmt
- drop_schedule_stmt
- export_stmt
- for_schedules_clause
- insert_rest
- pause_jobs_stmt
- pause_schedules_stmt
- preparable_stmt
- resume_jobs_stmt
- resume_schedules_stmt
- row_source_extension_stmt
- show_jobs_stmt
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
- alter_rename_table_stmt
- alter_scatter_stmt
- alter_split_stmt
- alter_unsplit_stmt
- alter_zone_partition_stmt
- alter_zone_table_stmt
- analyze_target
- 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_partitions_stmt
- show_range_for_row_stmt
- show_ranges_stmt
- show_stats_stmt
- show_zone_stmt
- single_table_pattern_list
- sortby
- table_elem
- table_index_name
- table_name_list
- table_name_opt_idx
- view_name
referenced by:
referenced by:
referenced by:
- constraint_elem
- copy_from_stmt
- create_index_stmt
- delete_stmt
- index_def
- on_conflict
- simple_select_clause
- update_stmt
referenced by:
- alter_database_owner
- alter_database_to_schema_stmt
- alter_rename_database_stmt
- alter_zone_database_stmt
- comment_stmt
- create_database_stmt
- drop_database_stmt
- scrub_database_stmt
- show_indexes_stmt
- show_partitions_stmt
- show_ranges_stmt
- show_zone_stmt
referenced by:
referenced by:
referenced by:
- alter_oneindex_stmt
- alter_rename_index_stmt
- alter_scatter_index_stmt
- alter_split_index_stmt
- alter_unsplit_index_stmt
- alter_zone_index_stmt
- alter_zone_partition_stmt
- comment_stmt
- show_partitions_stmt
- show_range_for_row_stmt
- show_ranges_stmt
- show_zone_stmt
- table_index_name_list
referenced by:
referenced by:
referenced by:
- alter_type_stmt
- column_name
- column_path
- constraint_name
- create_extension_stmt
- database_name
- db_object_name_component
- deallocate_stmt
- family_name
- import_format
- index_elem
- kv_option
- name_list
- opt_class
- opt_existing_window_name
- opt_index_access_method
- opt_name
- opt_name_parens
- privilege
- savepoint_name
- savepoint_stmt
- schema_name
- show_schemas_stmt
- show_sequences_stmt
- show_tables_stmt
- statistics_name
- storage_parameter
- table_alias_name
- var_name
- window_name
referenced by:
referenced by:
referenced by:
- constraint_elem
- drop_schema_stmt
- family_def
- for_grantee_clause
- grant_stmt
- join_qual
- labeled_row
- on_conflict
- opt_column_list
- 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:
- alter_database_owner
- alter_schema_stmt
- alter_table_cmd
- alter_type_stmt
- create_schema_stmt
- reassign_owned_stmt
- role_spec_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:
string_or_placeholder_opt_list:
referenced by:
- backup_options
- backup_stmt
- create_schedule_for_backup_stmt
- list_of_string_or_placeholder_opt_list
- restore_options
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
create_schedule_for_backup_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:
- alter_role_stmt
- backup_options
- copy_options
- create_role_stmt
- export_stmt
- import_stmt
- kv_option
- opt_changefeed_sink
- opt_description
- password_clause
- restore_options
- restore_stmt
- show_backup_stmt
- string_or_placeholder_list
- string_or_placeholder_opt_list
- valid_until_clause
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
list_of_string_or_placeholder_opt_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:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
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_schema_stmt
- drop_sequence_stmt
- drop_table_stmt
- drop_type_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:
- alter_scatter_index_stmt
- alter_scatter_stmt
- distinct_on_clause
- execute_param_clause
- extract_list
- func_application
- func_expr_common_subexpr
- list_partition
- opt_expr_list
- opt_partition_clause
- overlay_list
- range_partition
- show_range_for_row_stmt
- special_function
- trim_list
- tuple1_ambiguous_values
- tuple1_unambiguous_values
- values_clause
referenced by:
- name
- non_reserved_word
- targets
- type_function_name
- type_function_name_no_crdb_extra
- unrestricted_name
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
- role_spec
- 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:
- a_expr
- alter_column_default
- alter_split_index_stmt
- alter_split_stmt
- 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
- drop_schedule_stmt
- expr_list
- extract_list
- filter_clause
- for_schedules_clause
- frame_bound
- func_expr_common_subexpr
- group_by_item
- having_clause
- index_elem
- join_qual
- limit_clause
- offset_clause
- opt_alter_column_using
- opt_hash_sharded
- opt_slice_bound
- overlay_list
- overlay_placing
- pause_jobs_stmt
- pause_schedules_stmt
- resume_jobs_stmt
- resume_schedules_stmt
- show_jobs_stmt
- show_schedules_stmt
- single_set_clause
- sortby
- special_function
- 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:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
referenced by:
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
- alter_sequence_set_schema_stmt
- alter_table_set_schema_stmt
- alter_view_set_schema_stmt
- relation_expr_list
- table_ref
referenced by:
referenced by:
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
- complex_type_name
- 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: