SQL Grammar

Tip:

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.

stmt_block:

stmt

no references


stmt:

HELPTOKEN stmt_without_legacy_transaction legacy_transaction_stmt

referenced by:


stmt_without_legacy_transaction:

preparable_stmt analyze_stmt call_stmt copy_stmt comment_stmt execute_stmt deallocate_stmt discard_stmt grant_stmt prepare_stmt revoke_stmt savepoint_stmt reassign_owned_by_stmt drop_owned_by_stmt release_stmt refresh_stmt nonpreparable_set_stmt transaction_stmt close_cursor_stmt declare_cursor_stmt fetch_cursor_stmt move_cursor_stmt unlisten_stmt show_commit_timestamp_stmt

referenced by:


legacy_transaction_stmt:

legacy_begin_stmt legacy_end_stmt

referenced by:


preparable_stmt:

alter_stmt backup_stmt cancel_stmt create_stmt delete_stmt drop_stmt explain_stmt import_stmt insert_stmt pause_stmt reset_stmt restore_stmt resume_stmt export_stmt scrub_stmt select_stmt preparable_set_stmt show_stmt truncate_stmt update_stmt upsert_stmt

referenced by:


analyze_stmt:

ANALYZE ANALYSE analyze_target

referenced by:


call_stmt:

CALL func_application

referenced by:


copy_stmt:

COPY table_name opt_column_list FROM STDIN opt_with_copy_options opt_where_clause TO STDOUT opt_with_copy_options ( copy_to_stmt ) TO STDOUT opt_with_copy_options

referenced by:


comment_stmt:

COMMENT ON DATABASE database_name SCHEMA qualifiable_schema_name TYPE type_name TABLE CONSTRAINT constraint_name ON table_name COLUMN column_path INDEX table_index_name IS comment_text

referenced by:


execute_stmt:

EXECUTE table_alias_name execute_param_clause

referenced by:


deallocate_stmt:

DEALLOCATE PREPARE name ALL

referenced by:


discard_stmt:

DISCARD ALL SEQUENCES TEMP TEMPORARY

referenced by:


grant_stmt:

GRANT privileges ON grant_targets TYPE target_types ALL SEQUENCES TABLES FUNCTIONS PROCEDURES IN SCHEMA schema_name_list SYSTEM privileges TO role_spec_list opt_with_grant_option privilege_list TO role_spec_list WITH ADMIN OPTION

referenced by:


prepare_stmt:

PREPARE table_alias_name prep_type_clause AS preparable_stmt

referenced by:


revoke_stmt:

REVOKE privileges ON grant_targets TYPE target_types ALL TABLES SEQUENCES FUNCTIONS PROCEDURES IN SCHEMA schema_name_list ADMIN OPTION FOR privilege_list SYSTEM privileges GRANT OPTION FOR privileges ON grant_targets TYPE target_types ALL TABLES FUNCTIONS PROCEDURES IN SCHEMA schema_name_list SYSTEM privileges FROM role_spec_list

referenced by:


savepoint_stmt:

SAVEPOINT name

referenced by:


reassign_owned_by_stmt:

REASSIGN OWNED BY role_spec_list TO role_spec

referenced by:


drop_owned_by_stmt:

DROP OWNED BY role_spec_list opt_drop_behavior

referenced by:


release_stmt:

RELEASE savepoint_name

referenced by:


refresh_stmt:

REFRESH MATERIALIZED VIEW opt_concurrently view_name opt_clear_data

referenced by:


nonpreparable_set_stmt:

set_transaction_stmt

referenced by:


transaction_stmt:

begin_stmt commit_stmt rollback_stmt abort_stmt

referenced by:


close_cursor_stmt:

CLOSE ALL cursor_name

referenced by:


declare_cursor_stmt:

DECLARE cursor_name opt_binary opt_sensitivity opt_scroll CURSOR opt_hold FOR select_stmt

referenced by:


fetch_cursor_stmt:

FETCH cursor_movement_specifier

referenced by:


move_cursor_stmt:

MOVE cursor_movement_specifier

referenced by:


unlisten_stmt:

UNLISTEN type_name *

referenced by:


show_commit_timestamp_stmt:

SHOW COMMIT TIMESTAMP

referenced by:


legacy_begin_stmt:

BEGIN opt_transaction begin_transaction

referenced by:


legacy_end_stmt:

END opt_transaction

referenced by:


alter_stmt:

alter_ddl_stmt alter_role_stmt

referenced by:


backup_stmt:

BACKUP opt_backup_targets INTO sconst_or_placeholder LATEST IN string_or_placeholder_opt_list opt_as_of_clause opt_with_backup_options

referenced by:


cancel_stmt:

cancel_jobs_stmt cancel_queries_stmt cancel_sessions_stmt cancel_all_jobs_stmt

referenced by:


create_stmt:

create_role_stmt create_ddl_stmt create_stats_stmt create_changefeed_stmt create_extension_stmt create_external_connection_stmt create_schedule_stmt

referenced by:


delete_stmt:

opt_with_clause DELETE opt_batch_clause FROM table_expr_opt_alias_idx opt_using_clause opt_where_clause opt_sort_clause opt_limit_clause returning_clause

referenced by:


drop_stmt:

drop_ddl_stmt drop_role_stmt drop_schedule_stmt drop_external_connection_stmt

referenced by:


explain_stmt:

EXPLAIN ANALYZE ANALYSE ( explain_option_list ) explainable_stmt

referenced by:


import_stmt:

IMPORT TABLE table_name FROM import_format string_or_placeholder INTO table_name ( insert_column_list ) import_format DATA ( string_or_placeholder_list ) opt_with_options

referenced by:


insert_stmt:

opt_with_clause INSERT INTO insert_target insert_rest on_conflict returning_clause

referenced by:


pause_stmt:

pause_jobs_stmt pause_schedules_stmt pause_all_jobs_stmt

referenced by:


reset_stmt:

reset_session_stmt reset_csetting_stmt

referenced by:


restore_stmt:

RESTORE backup_targets SYSTEM USERS FROM string_or_placeholder IN list_of_string_or_placeholder_opt_list opt_as_of_clause opt_with_restore_options

referenced by:


resume_stmt:

resume_jobs_stmt resume_schedules_stmt resume_all_jobs_stmt

referenced by:


export_stmt:

EXPORT INTO import_format string_or_placeholder opt_with_options FROM select_stmt

referenced by:


scrub_stmt:

scrub_table_stmt scrub_database_stmt

referenced by:


select_stmt:

select_no_parens select_with_parens

referenced by:


preparable_set_stmt:

set_session_stmt set_local_stmt set_csetting_stmt use_stmt

referenced by:


show_stmt:

show_backup_stmt show_columns_stmt show_constraints_stmt show_create_stmt show_create_schedules_stmt show_create_external_connections_stmt show_databases_stmt show_enums_stmt show_external_connections_stmt show_types_stmt show_functions_stmt show_procedures_stmt show_grants_stmt show_indexes_stmt show_partitions_stmt show_jobs_stmt show_locality_stmt show_schedules_stmt show_statements_stmt show_ranges_stmt show_range_for_row_stmt show_regions_stmt show_survival_goal_stmt show_roles_stmt show_savepoint_stmt show_schemas_stmt show_sequences_stmt show_session_stmt show_sessions_stmt show_stats_stmt show_tables_stmt show_trace_stmt show_transactions_stmt show_transfer_stmt show_users_stmt show_default_session_variables_for_role_stmt show_zone_stmt show_full_scans_stmt show_default_privileges_stmt

referenced by:


truncate_stmt:

TRUNCATE opt_table relation_expr_list opt_drop_behavior

referenced by:


update_stmt:

opt_with_clause UPDATE table_expr_opt_alias_idx SET set_clause_list opt_from_list opt_where_clause opt_sort_clause opt_limit_clause returning_clause

referenced by:


upsert_stmt:

opt_with_clause UPSERT INTO insert_target insert_rest returning_clause

referenced by:


analyze_target:

table_name

referenced by:


func_application:

func_application_name ( ALL expr_list opt_sort_clause_no_index DISTINCT expr_list * )

referenced by:


table_name:

db_object_name

referenced by:


opt_column_list:

( name_list )

referenced by:


opt_with_copy_options:

opt_with copy_options_list ( copy_generic_options_list )

referenced by:


opt_where_clause:

where_clause

referenced by:


copy_to_stmt:

delete_stmt insert_stmt select_stmt update_stmt upsert_stmt

referenced by:


database_name:

name

referenced by:


comment_text:

SCONST NULL

referenced by:


qualifiable_schema_name:

name . name

referenced by:


type_name:

db_object_name

referenced by:


column_path:

name prefixed_column_path

referenced by:


table_index_name:

table_name @ index_name standalone_index_name

referenced by:


constraint_name:

name

referenced by:


table_alias_name:

name

referenced by:


execute_param_clause:

( expr_list )

referenced by:


name:

identifier unreserved_keyword col_name_keyword

referenced by:


privileges:

ALL opt_privileges_clause privilege_list

referenced by:


grant_targets:

identifier col_name_keyword unreserved_keyword complex_table_pattern SEQUENCE table_pattern , TABLE table_pattern_list DATABASE EXTERNAL CONNECTION name_list FUNCTION PROCEDURE function_with_paramtypes_list

referenced by:


role_spec_list:

role_spec ,

referenced by:


opt_with_grant_option:

WITH GRANT OPTION

referenced by:


privilege_list:

privilege ,

referenced by:


target_types:

type_name_list

referenced by:


schema_name_list:

qualifiable_schema_name ,

referenced by:


prep_type_clause:

( type_list )

referenced by:


role_spec:

identifier unreserved_keyword CURRENT_USER SESSION_USER

referenced by:


opt_drop_behavior:

CASCADE RESTRICT

referenced by:


savepoint_name:

SAVEPOINT name

referenced by:


opt_concurrently:

CONCURRENTLY

referenced by:


view_name:

table_name

referenced by:


opt_clear_data:

WITH NO DATA

referenced by:


set_transaction_stmt:

SET SESSION TRANSACTION transaction_mode_list

referenced by:


begin_stmt:

START TRANSACTION begin_transaction

referenced by:


commit_stmt:

COMMIT opt_transaction

referenced by:


rollback_stmt:

ROLLBACK opt_transaction TO savepoint_name

referenced by:


abort_stmt:

ABORT opt_abort_mod

referenced by:


cursor_name:

name

referenced by:


opt_binary:

BINARY

referenced by:


opt_sensitivity:

INSENSITIVE ASENSITIVE

referenced by:


opt_scroll:

NO SCROLL

referenced by:


opt_hold:

WITH WITHOUT HOLD

referenced by:


cursor_movement_specifier:

from_or_in next_prior forward_backward ABSOLUTE RELATIVE signed_iconst64 FIRST LAST opt_forward_backward signed_iconst64 ALL opt_from_or_in cursor_name

referenced by:


opt_transaction:

TRANSACTION

referenced by:


begin_transaction:

transaction_mode_list

referenced by:


alter_ddl_stmt:

alter_table_stmt alter_index_stmt alter_view_stmt alter_sequence_stmt alter_database_stmt alter_range_stmt alter_partition_stmt alter_schema_stmt alter_type_stmt alter_default_privileges_stmt alter_changefeed_stmt alter_backup_stmt alter_func_stmt alter_proc_stmt alter_backup_schedule

referenced by:


alter_role_stmt:

ALTER role_or_group_or_user IF EXISTS role_spec opt_role_options opt_in_database set_or_reset_clause ROLE_ALL USER_ALL ALL opt_in_database set_or_reset_clause

referenced by:


opt_backup_targets:

backup_targets

referenced by:


sconst_or_placeholder:

SCONST PLACEHOLDER

referenced by:


string_or_placeholder_opt_list:

string_or_placeholder ( string_or_placeholder_list )

referenced by:


opt_as_of_clause:

as_of_clause

referenced by:


opt_with_backup_options:

WITH backup_options_list OPTIONS ( backup_options_list )

referenced by:


cancel_jobs_stmt:

CANCEL JOB a_expr JOBS select_stmt for_schedules_clause

referenced by:


cancel_queries_stmt:

CANCEL QUERY IF EXISTS a_expr QUERIES IF EXISTS select_stmt

referenced by:


cancel_sessions_stmt:

CANCEL SESSION IF EXISTS a_expr SESSIONS IF EXISTS select_stmt

referenced by:


cancel_all_jobs_stmt:

CANCEL ALL name JOBS

referenced by:


create_role_stmt:

CREATE role_or_group_or_user IF NOT EXISTS role_spec opt_role_options

referenced by:


create_ddl_stmt:

create_database_stmt create_index_stmt create_schema_stmt create_table_stmt create_table_as_stmt create_type_stmt create_view_stmt create_sequence_stmt create_func_stmt create_proc_stmt create_trigger_stmt

referenced by:


create_stats_stmt:

CREATE STATISTICS statistics_name opt_stats_columns FROM create_stats_target opt_create_stats_options

referenced by:


create_changefeed_stmt:

CREATE CHANGEFEED FOR changefeed_targets opt_changefeed_sink opt_with_options opt_changefeed_sink opt_with_options AS SELECT target_list FROM changefeed_target_expr opt_where_clause

referenced by:


create_extension_stmt:

CREATE EXTENSION IF NOT EXISTS name

referenced by:


create_external_connection_stmt:

CREATE EXTERNAL CONNECTION label_spec AS string_or_placeholder

referenced by:


create_schedule_stmt:

create_schedule_for_changefeed_stmt create_schedule_for_backup_stmt

referenced by:


opt_with_clause:

with_clause

referenced by:


opt_batch_clause:

BATCH ( batch_param_list )

referenced by:


table_expr_opt_alias_idx:

table_name_opt_idx AS table_alias_name

referenced by:


opt_using_clause:

USING from_list

referenced by:


opt_sort_clause:

sort_clause

referenced by:


opt_limit_clause:

limit_clause

referenced by:


returning_clause:

RETURNING target_list NOTHING

referenced by:


drop_ddl_stmt:

drop_database_stmt drop_index_stmt drop_table_stmt drop_view_stmt drop_sequence_stmt drop_schema_stmt drop_type_stmt drop_func_stmt drop_proc_stmt drop_trigger_stmt

referenced by:


drop_role_stmt:

DROP role_or_group_or_user IF EXISTS role_spec_list

referenced by:


drop_schedule_stmt:

DROP SCHEDULE a_expr SCHEDULES select_stmt

referenced by:


drop_external_connection_stmt:

DROP EXTERNAL CONNECTION string_or_placeholder

referenced by:


explainable_stmt:

preparable_stmt comment_stmt execute_stmt call_stmt

referenced by:


explain_option_list:

explain_option_name ,

referenced by:


import_format:

name

referenced by:


string_or_placeholder:

non_reserved_word_or_sconst PLACEHOLDER

referenced by:


opt_with_options:

WITH kv_option_list OPTIONS ( kv_option_list )

referenced by:


insert_column_list:

insert_column_item ,

referenced by:


string_or_placeholder_list:

string_or_placeholder ,

referenced by:


insert_target:

table_name_opt_idx AS table_alias_name

referenced by:


insert_rest:

( insert_column_list ) select_stmt DEFAULT VALUES

referenced by:


on_conflict:

ON CONFLICT DO NOTHING ( name_list ) opt_where_clause ON CONSTRAINT constraint_name DO NOTHING UPDATE SET set_clause_list opt_where_clause

referenced by:


pause_jobs_stmt:

PAUSE JOB a_expr WITH REASON = string_or_placeholder JOBS select_stmt WITH REASON = string_or_placeholder for_schedules_clause

referenced by:


pause_schedules_stmt:

PAUSE SCHEDULE a_expr SCHEDULES select_stmt

referenced by:


pause_all_jobs_stmt:

PAUSE ALL name JOBS

referenced by:


reset_session_stmt:

RESET SESSION session_var RESET_ALL ALL

referenced by:


reset_csetting_stmt:

RESET CLUSTER SETTING var_name

referenced by:


list_of_string_or_placeholder_opt_list:

string_or_placeholder_opt_list ,

referenced by:


opt_with_restore_options:

WITH restore_options_list OPTIONS ( restore_options_list )

referenced by:


backup_targets:

identifier col_name_keyword unreserved_keyword complex_table_pattern table_pattern , TABLE table_pattern_list DATABASE name_list

referenced by:


resume_jobs_stmt:

RESUME JOB a_expr JOBS select_stmt for_schedules_clause

referenced by:


resume_schedules_stmt:

RESUME SCHEDULE a_expr SCHEDULES select_stmt

referenced by:


resume_all_jobs_stmt:

RESUME ALL name JOBS

referenced by:


scrub_table_stmt:

EXPERIMENTAL SCRUB TABLE table_name opt_as_of_clause opt_scrub_options_clause

referenced by:


scrub_database_stmt:

EXPERIMENTAL SCRUB DATABASE database_name opt_as_of_clause

referenced by:


select_no_parens:

simple_select select_clause sort_clause opt_sort_clause for_locking_clause opt_select_limit select_limit opt_for_locking_clause with_clause select_clause sort_clause opt_sort_clause for_locking_clause opt_select_limit select_limit opt_for_locking_clause

referenced by:


select_with_parens:

( select_no_parens select_with_parens )

referenced by:


set_session_stmt:

SET SESSION set_rest_more CHARACTERISTICS AS TRANSACTION transaction_mode_list set_rest_more

referenced by:


set_local_stmt:

SET LOCAL set_rest

referenced by:


set_csetting_stmt:

SET CLUSTER SETTING var_name to_or_eq var_value

referenced by:


use_stmt:

USE var_value

referenced by:


show_backup_stmt:

SHOW BACKUPS IN string_or_placeholder_opt_list BACKUP SCHEMAS FROM string_or_placeholder IN string_or_placeholder_opt_list opt_with_show_backup_options

referenced by:


show_columns_stmt:

SHOW COLUMNS FROM table_name with_comment

referenced by:


show_constraints_stmt:

SHOW CONSTRAINT CONSTRAINTS FROM table_name with_comment

referenced by:


show_create_stmt:

SHOW CREATE table_name opt_show_create_format_options ALL SCHEMAS TABLES TYPES

referenced by:


show_create_schedules_stmt:

SHOW CREATE ALL SCHEDULES SCHEDULE a_expr

referenced by:


show_create_external_connections_stmt:

SHOW CREATE ALL EXTERNAL CONNECTIONS EXTERNAL CONNECTION string_or_placeholder

referenced by:


show_databases_stmt:

SHOW DATABASES with_comment

referenced by:


show_enums_stmt:

SHOW ENUMS FROM name . name

referenced by:


show_external_connections_stmt:

SHOW EXTERNAL CONNECTIONS CONNECTION string_or_placeholder

referenced by:


show_types_stmt:

SHOW TYPES with_comment

referenced by:


show_functions_stmt:

SHOW FUNCTIONS FROM name . name

referenced by:


show_procedures_stmt:

SHOW PROCEDURES FROM name . name

referenced by:


show_grants_stmt:

SHOW GRANTS opt_on_targets_roles SYSTEM GRANTS for_grantee_clause

referenced by:


show_indexes_stmt:

SHOW INDEX INDEXES KEYS FROM table_name DATABASE database_name with_comment

referenced by:


show_partitions_stmt:

SHOW PARTITIONS FROM TABLE table_name DATABASE database_name INDEX table_index_name table_name @ *

referenced by:


show_jobs_stmt:

SHOW AUTOMATIC JOBS JOBS select_stmt WITH show_job_options_list WHEN COMPLETE select_stmt for_schedules_clause CHANGEFEED JOBS select_stmt JOB a_expr JOB a_expr WITH show_job_options_list WHEN COMPLETE a_expr

referenced by:


show_locality_stmt:

SHOW LOCALITY

referenced by:


show_schedules_stmt:

SHOW schedule_state SCHEDULES opt_schedule_executor_type SCHEDULE a_expr

referenced by:


show_statements_stmt:

SHOW ALL opt_cluster statements_or_queries

referenced by:


show_ranges_stmt:

SHOW RANGES FROM INDEX table_index_name TABLE table_name DATABASE database_name CURRENT_CATALOG CLUSTER RANGES opt_show_ranges_options

referenced by:


show_range_for_row_stmt:

SHOW RANGE FROM TABLE table_name INDEX table_index_name FOR ROW ( expr_list )

referenced by:


show_regions_stmt:

SHOW REGIONS FROM CLUSTER DATABASE database_name ALL DATABASES SUPER REGIONS FROM DATABASE database_name

referenced by:


show_survival_goal_stmt:

SHOW SURVIVAL GOAL FROM DATABASE database_name

referenced by:


show_roles_stmt:

SHOW ROLES

referenced by:


show_savepoint_stmt:

SHOW SAVEPOINT STATUS

referenced by:


show_schemas_stmt:

SHOW SCHEMAS FROM name with_comment

referenced by:


show_sequences_stmt:

SHOW SEQUENCES FROM name

referenced by:


show_session_stmt:

SHOW SESSION session_var

referenced by:


show_sessions_stmt:

SHOW ALL opt_cluster SESSIONS

referenced by:


show_stats_stmt:

SHOW STATISTICS FOR TABLE table_name opt_with_options

referenced by:


show_tables_stmt:

SHOW TABLES FROM name . name with_comment

referenced by:


show_trace_stmt:

SHOW opt_compact KV TRACE FOR SESSION

referenced by:


show_transactions_stmt:

SHOW ALL opt_cluster TRANSACTIONS

referenced by:


show_transfer_stmt:

SHOW TRANSFER STATE WITH SCONST

referenced by:


show_users_stmt:

SHOW USERS

referenced by:


show_default_session_variables_for_role_stmt:

SHOW DEFAULT SESSION VARIABLES FOR role_or_group_or_user role_spec ROLE_ALL USER_ALL ALL

referenced by:


show_zone_stmt:

SHOW ZONE CONFIGURATION FROM RANGE zone_name DATABASE database_name TABLE table_name INDEX table_index_name opt_partition PARTITION partition_name OF TABLE table_name INDEX table_index_name CONFIGURATIONS ALL ZONE CONFIGURATIONS

referenced by:


show_full_scans_stmt:

SHOW FULL TABLE SCANS

referenced by:


show_default_privileges_stmt:

SHOW DEFAULT PRIVILEGES opt_for_roles FOR GRANTEE role_spec_list ALL ROLES opt_in_schema

referenced by:


opt_table:

TABLE

referenced by:


relation_expr_list:

relation_expr ,

referenced by:


set_clause_list:

set_clause ,

referenced by:


opt_from_list:

FROM from_list

referenced by:


func_application_name:

func_name [ FUNCTION ICONST ]

referenced by:


expr_list:

a_expr ,

referenced by:


opt_sort_clause_no_index:

sort_clause_no_index

referenced by:


db_object_name:

simple_db_object_name complex_db_object_name

referenced by:


name_list:

name ,

referenced by:


opt_with:

WITH

referenced by:


copy_options_list:

copy_options

referenced by:


copy_generic_options_list:

copy_generic_options ,

referenced by:


where_clause:

WHERE a_expr

referenced by:


prefixed_column_path:

db_object_name_component . unrestricted_name . unrestricted_name . unrestricted_name

referenced by:


index_name:

unrestricted_name

referenced by:


standalone_index_name:

db_object_name

referenced by:


unreserved_keyword:

ABORT ABSOLUTE ACTION ACCESS ADD ADMIN AFTER AGGREGATE ALTER ALWAYS ASENSITIVE AS_JSON AT ATOMIC ATTRIBUTE AUTOMATIC AVAILABILITY BACKUP BACKUPS BACKWARD BATCH BEFORE BEGIN BINARY BUCKET_COUNT BUNDLE BY CACHE CALL CALLED CANCEL CANCELQUERY CAPABILITIES CAPABILITY CASCADE CHANGEFEED CHECK_FILES CLOSE CLUSTER CLUSTERS COLUMNS COMMENT COMMENTS COMMIT COMMITTED COMPACT COMPLETE COMPLETIONS CONFLICT CONFIGURATION CONFIGURATIONS CONFIGURE CONNECTION CONNECTIONS CONSTRAINTS CONTROLCHANGEFEED CONTROLJOB CONVERSION CONVERT COPY COST COVERING CREATEDB CREATELOGIN CREATEROLE CSV CUBE CURRENT CURSOR CYCLE DATA DATABASE DATABASES DAY DEALLOCATE DEBUG_IDS DEBUG_DUMP_METADATA_SST DECLARE DELETE DEFAULTS DEFERRED DEFINER DELIMITER DEPENDS DESTINATION DETACHED DETAILS DISCARD DOMAIN DOUBLE DROP EACH ENCODING ENCRYPTED ENCRYPTION_PASSPHRASE ENCRYPTION_INFO_DIR ENUM ENUMS ESCAPE EXCLUDE EXCLUDING EXECUTE EXECUTION EXPERIMENTAL EXPERIMENTAL_AUDIT EXPERIMENTAL_FINGERPRINTS EXPERIMENTAL_RELOCATE EXPERIMENTAL_REPLICA EXPIRATION EXPLAIN EXPORT EXTENSION EXTERNAL EXTREMES FAILURE FILES FILTER FIRST FOLLOWING FORMAT FORCE FORCE_NOT_NULL FORCE_NULL FORCE_QUOTE FORCE_INDEX FORCE_INVERTED_INDEX FORCE_ZIGZAG FORWARD FREEZE FUNCTION FUNCTIONS GENERATED GEOMETRYM GEOMETRYZ GEOMETRYZM GEOMETRYCOLLECTION GEOMETRYCOLLECTIONM GEOMETRYCOLLECTIONZ GEOMETRYCOLLECTIONZM GLOBAL GOAL GRANTEE GRANTS GROUPS HASH HEADER HIGH HISTOGRAM HOLD HOUR IDENTITY IMMEDIATE IMMEDIATELY IMMUTABLE IMPORT INCLUDE INCLUDING INCLUDE_ALL_SECONDARY_TENANTS INCLUDE_ALL_VIRTUAL_CLUSTERS INCREMENT INCREMENTAL INCREMENTAL_LOCATION INDEX INDEXES INHERITS INJECT INPUT INSERT INSTEAD INTO_DB INVERTED INVISIBLE ISOLATION INVOKER JOB JOBS JSON KEY KEYS KMS KV LABEL LANGUAGE LAST LATEST LC_COLLATE LC_CTYPE LEAKPROOF LEASE LESS LEVEL LINESTRING LINESTRINGM LINESTRINGZ LINESTRINGZM LIST LOCAL LOCKED LOGICAL LOGIN LOCALITY LOOKUP LOW MATCH MATERIALIZED MAXVALUE MERGE METHOD MINUTE MINVALUE MODIFYCLUSTERSETTING MODIFYSQLCLUSTERSETTING MULTILINESTRING MULTILINESTRINGM MULTILINESTRINGZ MULTILINESTRINGZM MULTIPOINT MULTIPOINTM MULTIPOINTZ MULTIPOINTZM MULTIPOLYGON MULTIPOLYGONM MULTIPOLYGONZ MULTIPOLYGONZM MODE MONTH MOVE NAMES NAN NEVER NEW NEW_DB_NAME NEW_KMS NEXT NO NORMAL NOTHING NO_INDEX_JOIN NO_ZIGZAG_JOIN NO_FULL_SCAN NOCREATEDB NOCREATELOGIN NOCANCELQUERY NOCREATEROLE NOCONTROLCHANGEFEED NOCONTROLJOB NODE NOLOGIN NOMODIFYCLUSTERSETTING NONVOTERS NOREPLICATION NOSQLLOGIN NOVIEWACTIVITY NOVIEWACTIVITYREDACTED NOVIEWCLUSTERSETTING NOWAIT NULLS IGNORE_FOREIGN_KEYS INSENSITIVE OF OFF OIDS OLD OLD_KMS OPERATOR OPT OPTION OPTIONS ORDINALITY OTHERS OVER OWNED OWNER PARALLEL PARENT PARTIAL PARTITION PARTITIONS PASSWORD PAUSE PAUSED PER PHYSICAL PLACEMENT PLAN PLANS POINTM POINTZ POINTZM POLYGONM POLYGONZ POLYGONZM PRECEDING PREPARE PRESERVE PRIOR PRIORITY PRIVILEGES PROCEDURE PROCEDURES PUBLIC PUBLICATION QUERIES QUERY QUOTE RANGE RANGES READ REASON REASSIGN RECURRING RECURSIVE REDACT REF REFERENCING REFRESH REGION REGIONAL REGIONS REINDEX RELATIVE RELEASE RELOCATE REMOVE_REGIONS RENAME REPEATABLE REPLACE REPLICATION RESET RESTART RESTORE RESTRICT RESTRICTED RESUME RETENTION RETRY RETURN RETURNS REVISION_HISTORY REVOKE ROLE ROLES ROLLBACK ROLLUP ROUTINES ROWS RULE RUNNING SCHEDULE SCHEDULES SCHEMA_ONLY SCROLL SETTING SETTINGS STATUS SAVEPOINT SCANS SCATTER SCHEMA SCHEMAS SCRUB SEARCH SECOND SECURITY SECONDARY SERIALIZABLE SEQUENCE SEQUENCES SERVER SERVICE SESSION SESSIONS SET SETS SHARE SHARED SHOW SIMPLE SIZE SKIP SKIP_LOCALITIES_CHECK SKIP_MISSING_FOREIGN_KEYS SKIP_MISSING_SEQUENCES SKIP_MISSING_SEQUENCE_OWNERS SKIP_MISSING_VIEWS SKIP_MISSING_UDFS SNAPSHOT SPLIT SQL SQLLOGIN STABLE START STATE STATEMENT STATEMENTS STATISTICS STDIN STDOUT STOP STORAGE STORE STORED STORING STRAIGHT STREAM STRICT SUBSCRIPTION SUBJECT SUPER SUPPORT SURVIVE SURVIVAL SYNTAX SYSTEM TABLES TABLESPACE TEMP TEMPLATE TEMPORARY TENANT TENANT_NAME TENANTS TESTING_RELOCATE TEXT TIES TRACE TRACING TRANSACTION TRANSACTIONS TRANSFER TRANSFORM TRIGGER TRUNCATE TRUSTED TYPE TYPES THROTTLING UNBOUNDED UNCOMMITTED UNKNOWN UNLISTEN UNLOGGED UNSAFE_RESTORE_INCOMPATIBLE_VERSION UNSET UNSPLIT UNTIL UPDATE UPDATES_CLUSTER_MONITORING_METRICS UPSERT USE USERS VALID VALIDATE VALUE VARIABLES VARYING VERIFY_BACKUP_TABLE_DATA VIEW VIEWACTIVITY VIEWACTIVITYREDACTED VIEWCLUSTERMETADATA VIEWCLUSTERSETTING VIEWDEBUG VIRTUAL_CLUSTER_NAME VIRTUAL_CLUSTER VISIBLE VISIBILITY VOLATILE VOTERS WITHIN WITHOUT WRITE YEAR ZONE

referenced by:


col_name_keyword:

ANNOTATE_TYPE BETWEEN BIGINT BIT BOOLEAN BOX2D CHAR CHARACTER CHARACTERISTICS COALESCE DEC DECIMAL EXISTS EXTRACT EXTRACT_DURATION FLOAT GEOGRAPHY GEOMETRY GREATEST GROUPING IF IFERROR IFNULL INOUT INT INTEGER INTERVAL ISERROR LEAST NULLIF NUMERIC OUT OVERLAY POINT POLYGON POSITION PRECISION REAL ROW SETOF SMALLINT STRING SUBSTRING TIME TIMETZ TIMESTAMP TIMESTAMPTZ TREAT TRIM VALUES VARBIT VARCHAR VECTOR VIRTUAL WORK

referenced by:


opt_privileges_clause:

PRIVILEGES

referenced by:


complex_table_pattern:

complex_db_object_name db_object_name_component . unrestricted_name . *

referenced by:


table_pattern_list:

table_pattern ,

referenced by:


table_pattern:

simple_db_object_name complex_table_pattern

referenced by:


function_with_paramtypes_list:

function_with_paramtypes ,

referenced by:


privilege:

name CREATE GRANT SELECT

referenced by:


type_name_list:

type_name ,

referenced by:


type_list:

typename ,

referenced by:


transaction_mode_list:

transaction_mode opt_comma

referenced by:


opt_abort_mod:

TRANSACTION WORK

referenced by:


from_or_in:

FROM IN

referenced by:


next_prior:

NEXT PRIOR

referenced by:


opt_from_or_in:

from_or_in

referenced by:


forward_backward:

FORWARD BACKWARD

referenced by:


opt_forward_backward:

forward_backward

referenced by:


signed_iconst64:

signed_iconst

referenced by:


alter_table_stmt:

alter_onetable_stmt alter_split_stmt alter_unsplit_stmt alter_scatter_stmt alter_zone_table_stmt alter_rename_table_stmt alter_table_set_schema_stmt alter_table_locality_stmt alter_table_owner_stmt

referenced by:


alter_index_stmt:

alter_oneindex_stmt alter_split_index_stmt alter_unsplit_index_stmt alter_scatter_index_stmt alter_rename_index_stmt alter_zone_index_stmt alter_index_visible_stmt

referenced by:


alter_view_stmt:

alter_rename_view_stmt alter_view_set_schema_stmt alter_view_owner_stmt

referenced by:


alter_sequence_stmt:

alter_rename_sequence_stmt alter_sequence_options_stmt alter_sequence_set_schema_stmt alter_sequence_owner_stmt

referenced by:


alter_database_stmt:

alter_rename_database_stmt alter_zone_database_stmt alter_database_owner alter_database_to_schema_stmt alter_database_add_region_stmt alter_database_drop_region_stmt alter_database_survival_goal_stmt alter_database_primary_region_stmt alter_database_placement_stmt alter_database_set_stmt alter_database_add_super_region alter_database_alter_super_region alter_database_drop_super_region alter_database_set_secondary_region_stmt alter_database_drop_secondary_region alter_database_set_zone_config_extension_stmt

referenced by:


alter_range_stmt:

alter_zone_range_stmt alter_range_relocate_stmt

referenced by:


alter_partition_stmt:

alter_zone_partition_stmt

referenced by:


alter_schema_stmt:

ALTER SCHEMA qualifiable_schema_name RENAME TO schema_name OWNER TO role_spec

referenced by:


alter_type_stmt:

ALTER TYPE type_name ADD VALUE IF NOT EXISTS SCONST opt_add_val_placement DROP VALUE SCONST RENAME VALUE SCONST TO SCONST TO name SET SCHEMA schema_name OWNER TO role_spec

referenced by:


alter_default_privileges_stmt:

ALTER DEFAULT PRIVILEGES opt_for_roles FOR ALL ROLES opt_in_schemas abbreviated_grant_stmt abbreviated_revoke_stmt

referenced by:


alter_changefeed_stmt:

ALTER CHANGEFEED a_expr alter_changefeed_cmds

referenced by:


alter_backup_stmt:

ALTER BACKUP string_or_placeholder IN string_or_placeholder alter_backup_cmds

referenced by:


alter_func_stmt:

alter_func_options_stmt alter_func_rename_stmt alter_func_owner_stmt alter_func_set_schema_stmt alter_func_dep_extension_stmt

referenced by:


alter_proc_stmt:

alter_proc_rename_stmt alter_proc_owner_stmt alter_proc_set_schema_stmt

referenced by:


alter_backup_schedule:

ALTER BACKUP SCHEDULE ICONST alter_backup_schedule_cmds

referenced by:


role_or_group_or_user:

ROLE USER

referenced by:


opt_role_options:

opt_with role_options

referenced by:


opt_in_database:

IN DATABASE database_name

referenced by:


set_or_reset_clause:

SET set_rest RESET_ALL ALL RESET session_var

referenced by:


as_of_clause:

AS OF SYSTEM TIME a_expr

referenced by:


backup_options_list:

backup_options ,

referenced by:


a_expr:

c_expr + - ~ SQRT CBRT qual_op NOT a_expr row OVERLAPS row DEFAULT TYPECAST cast_target TYPEANNOTATE typename COLLATE collation_name AT TIME ZONE a_expr + a_expr - a_expr * a_expr / a_expr FLOORDIV a_expr % a_expr ^ a_expr # a_expr & a_expr | a_expr < a_expr > a_expr ? a_expr JSON_SOME_EXISTS a_expr JSON_ALL_EXISTS a_expr CONTAINS a_expr CONTAINED_BY a_expr = a_expr CONCAT a_expr LSHIFT a_expr RSHIFT a_expr FETCHVAL a_expr FETCHTEXT a_expr FETCHVAL_PATH a_expr FETCHTEXT_PATH a_expr REMOVE_PATH a_expr INET_CONTAINED_BY_OR_EQUALS a_expr AND_AND a_expr AT_AT a_expr DISTANCE a_expr COS_DISTANCE a_expr NEG_INNER_PRODUCT a_expr INET_CONTAINS_OR_EQUALS a_expr LESS_EQUALS a_expr GREATER_EQUALS a_expr NOT_EQUALS a_expr qual_op a_expr AND a_expr OR a_expr LIKE a_expr LIKE a_expr ESCAPE a_expr NOT LIKE a_expr NOT LIKE a_expr ESCAPE a_expr ILIKE a_expr ILIKE a_expr ESCAPE a_expr NOT ILIKE a_expr NOT ILIKE a_expr ESCAPE a_expr SIMILAR TO a_expr SIMILAR TO a_expr ESCAPE a_expr NOT SIMILAR TO a_expr NOT SIMILAR TO a_expr ESCAPE a_expr ~ a_expr NOT_REGMATCH a_expr REGIMATCH a_expr NOT_REGIMATCH a_expr IS NAN IS NOT NAN IS NULL ISNULL IS NOT NULL NOTNULL IS TRUE IS NOT TRUE IS FALSE IS NOT FALSE IS UNKNOWN IS NOT UNKNOWN IS DISTINCT FROM a_expr IS NOT DISTINCT FROM a_expr IS OF ( type_list ) IS NOT OF ( type_list ) BETWEEN opt_asymmetric b_expr AND a_expr NOT BETWEEN opt_asymmetric b_expr AND a_expr BETWEEN SYMMETRIC b_expr AND a_expr NOT BETWEEN SYMMETRIC b_expr AND a_expr IN in_expr NOT IN in_expr subquery_op sub_type a_expr

referenced by:


for_schedules_clause:

FOR SCHEDULES select_stmt SCHEDULE a_expr

referenced by:


create_database_stmt:

CREATE DATABASE IF NOT EXISTS database_name opt_with opt_template_clause opt_encoding_clause opt_lc_collate_clause opt_lc_ctype_clause opt_connection_limit opt_primary_region_clause opt_regions_list opt_survival_goal_clause opt_placement_clause opt_owner_clause opt_super_region_clause opt_secondary_region_clause

referenced by:


create_index_stmt:

CREATE opt_unique INDEX opt_concurrently opt_index_name IF NOT EXISTS index_name ON table_name opt_index_access_method ( index_params ) opt_hash_sharded INVERTED INDEX opt_concurrently opt_index_name IF NOT EXISTS index_name ON table_name ( index_params ) opt_storing opt_partition_by_index opt_with_storage_parameter_list opt_where_clause opt_index_visible

referenced by:


create_schema_stmt:

CREATE SCHEMA IF NOT EXISTS qualifiable_schema_name opt_schema_name AUTHORIZATION role_spec

referenced by:


create_table_stmt:

CREATE opt_persistence_temp_table TABLE IF NOT EXISTS table_name ( opt_table_elem_list ) opt_partition_by_table opt_table_with opt_create_table_on_commit opt_locality

referenced by:


create_table_as_stmt:

CREATE opt_persistence_temp_table TABLE IF NOT EXISTS table_name create_as_opt_col_list opt_table_with AS select_stmt opt_create_table_on_commit

referenced by:


create_type_stmt:

CREATE TYPE IF NOT EXISTS type_name AS ENUM ( opt_enum_val_list ( opt_composite_type_list )

referenced by:


create_view_stmt:

CREATE opt_temp VIEW IF NOT EXISTS OR REPLACE opt_temp VIEW view_name opt_column_list AS select_stmt MATERIALIZED VIEW IF NOT EXISTS view_name opt_column_list AS select_stmt opt_with_data

referenced by:


create_sequence_stmt:

CREATE opt_temp SEQUENCE IF NOT EXISTS sequence_name opt_sequence_option_list

referenced by:


create_func_stmt:

CREATE opt_or_replace FUNCTION routine_create_name ( opt_routine_param_with_default_list ) RETURNS opt_return_set routine_return_type opt_create_routine_opt_list opt_routine_body

referenced by:


create_proc_stmt:

CREATE opt_or_replace PROCEDURE routine_create_name ( opt_routine_param_with_default_list ) opt_create_routine_opt_list opt_routine_body

referenced by:


create_trigger_stmt:

CREATE opt_or_replace TRIGGER name trigger_action_time trigger_event_list ON table_name opt_trigger_transition_list trigger_for_each trigger_when EXECUTE function_or_procedure func_name ( trigger_func_args )

referenced by:


statistics_name:

name

referenced by:


opt_stats_columns:

ON name_list

referenced by:


create_stats_target:

table_name

referenced by:


opt_create_stats_options:

WITH OPTIONS create_stats_option_list

referenced by:


changefeed_targets:

changefeed_target ,

referenced by:


opt_changefeed_sink:

INTO string_or_placeholder

referenced by:


target_list:

target_elem ,

referenced by:


changefeed_target_expr:

insert_target

referenced by:


label_spec:

IF NOT EXISTS string_or_placeholder

referenced by:


create_schedule_for_changefeed_stmt:

CREATE SCHEDULE schedule_label_spec FOR CHANGEFEED changefeed_targets changefeed_sink opt_with_options changefeed_sink opt_with_options AS SELECT target_list FROM changefeed_target_expr opt_where_clause cron_expr opt_with_schedule_options

referenced by:


create_schedule_for_backup_stmt:

CREATE SCHEDULE schedule_label_spec FOR BACKUP opt_backup_targets INTO string_or_placeholder_opt_list opt_with_backup_options cron_expr opt_full_backup_clause opt_with_schedule_options

referenced by:


with_clause:

WITH RECURSIVE cte_list

referenced by:


batch_param_list:

batch_param ,

referenced by:


table_name_opt_idx:

opt_only table_name opt_index_flags opt_descendant

referenced by:


from_list:

table_ref ,

referenced by:


sort_clause:

ORDER BY sortby_list

referenced by:


limit_clause:

LIMIT ALL a_expr FETCH first_or_next select_fetch_first_value row_or_rows ONLY

referenced by:


drop_database_stmt:

DROP DATABASE IF EXISTS database_name opt_drop_behavior

referenced by:


drop_index_stmt:

DROP INDEX opt_concurrently IF EXISTS table_index_name_list opt_drop_behavior

referenced by:


drop_table_stmt:

DROP TABLE IF EXISTS table_name_list opt_drop_behavior

referenced by:


drop_view_stmt:

DROP MATERIALIZED VIEW IF EXISTS view_name_list opt_drop_behavior

referenced by:


drop_sequence_stmt:

DROP SEQUENCE IF EXISTS sequence_name_list opt_drop_behavior

referenced by:


drop_schema_stmt:

DROP SCHEMA IF EXISTS schema_name_list opt_drop_behavior

referenced by:


drop_type_stmt:

DROP TYPE IF EXISTS type_name_list opt_drop_behavior

referenced by:


drop_func_stmt:

DROP FUNCTION IF EXISTS function_with_paramtypes_list opt_drop_behavior

referenced by:


drop_proc_stmt:

DROP PROCEDURE IF EXISTS function_with_paramtypes_list opt_drop_behavior

referenced by:


drop_trigger_stmt:

DROP TRIGGER IF EXISTS name ON table_name opt_drop_behavior

referenced by:


explain_option_name:

non_reserved_word

referenced by:


non_reserved_word_or_sconst:

non_reserved_word SCONST

referenced by:


kv_option_list:

kv_option ,

referenced by:


insert_column_item:

column_name

referenced by:


session_var:

identifier session_var_parts ALL DATABASE NAMES ROLE SESSION_USER LC_COLLATE LC_CTYPE TIME ZONE VIRTUAL_CLUSTER_NAME

referenced by:


var_name:

name attrs

referenced by:


restore_options_list:

restore_options ,

referenced by:


opt_scrub_options_clause:

WITH OPTIONS scrub_option_list

referenced by:


simple_select:

simple_select_clause values_clause table_clause set_operation

referenced by:


select_clause:

simple_select select_with_parens

referenced by:


for_locking_clause:

for_locking_items FOR READ ONLY

referenced by:


opt_select_limit:

select_limit

referenced by:


select_limit:

limit_clause offset_clause offset_clause limit_clause

referenced by:


opt_for_locking_clause:

for_locking_clause

referenced by:


set_rest_more:

set_rest

referenced by:


set_rest:

generic_set

referenced by:


to_or_eq:

= TO

referenced by:


var_value:

a_expr extra_var_value

referenced by:


opt_with_show_backup_options:

WITH show_backup_options_list OPTIONS ( show_backup_options_list )

referenced by:


with_comment:

WITH COMMENT

referenced by:


opt_show_create_format_options:

WITH REDACT

referenced by:


opt_on_targets_roles:

ON targets_roles

referenced by:


for_grantee_clause:

FOR role_spec_list

referenced by:


show_job_options_list:

show_job_options ,

referenced by:


opt_schedule_executor_type:

FOR BACKUP SQL STATISTICS CHANGEFEED

referenced by:


schedule_state:

RUNNING PAUSED

referenced by:


opt_cluster:

CLUSTER LOCAL

referenced by:


statements_or_queries:

STATEMENTS QUERIES

referenced by:


opt_show_ranges_options:

WITH show_ranges_options

referenced by:


opt_compact:

COMPACT

referenced by:


zone_name:

unrestricted_name

referenced by:


opt_partition:

partition

referenced by:


partition_name:

unrestricted_name

referenced by:


opt_for_roles:

FOR role_or_group_or_user role_spec_list

referenced by:


opt_in_schema:

IN SCHEMA schema_name

referenced by:


relation_expr:

table_name * ONLY table_name ( table_name )

referenced by:


set_clause:

single_set_clause multiple_set_clause

referenced by:


func_name:

type_function_name prefixed_column_path INDEX

referenced by:


sort_clause_no_index:

ORDER BY sortby_no_index_list

referenced by:


simple_db_object_name:

db_object_name_component

referenced by:


complex_db_object_name:

db_object_name_component . unrestricted_name . unrestricted_name

referenced by:


copy_options:

DESTINATION = DELIMITER NULL string_or_placeholder BINARY CSV HEADER QUOTE ESCAPE ENCODING SCONST

referenced by:


copy_generic_options:

DESTINATION DELIMITER NULL string_or_placeholder FORMAT BINARY CSV TEXT SCONST HEADER TRUE FALSE QUOTE ESCAPE ENCODING SCONST

referenced by:


db_object_name_component:

name FAMILY cockroachdb_extra_reserved_keyword

referenced by:


unrestricted_name:

identifier unreserved_keyword col_name_keyword type_func_name_keyword reserved_keyword

referenced by:


function_with_paramtypes:

db_object_name func_params

referenced by:


typename:

simple_typename opt_array_bounds ARRAY

referenced by:


transaction_mode:

transaction_user_priority transaction_read_mode as_of_clause transaction_deferrable_mode

referenced by:


opt_comma:

,

referenced by:


signed_iconst:

ICONST only_signed_iconst

referenced by:


alter_onetable_stmt:

ALTER TABLE IF EXISTS relation_expr alter_table_cmds

referenced by:


alter_split_stmt:

ALTER TABLE table_name SPLIT AT select_stmt WITH EXPIRATION a_expr

referenced by:


alter_unsplit_stmt:

ALTER TABLE table_name UNSPLIT AT select_stmt ALL

referenced by:


alter_scatter_stmt:

ALTER TABLE table_name SCATTER FROM ( expr_list ) TO ( expr_list )

referenced by:


alter_zone_table_stmt:

ALTER TABLE table_name set_zone_config

referenced by:


alter_rename_table_stmt:

ALTER TABLE IF EXISTS relation_expr RENAME TO table_name

referenced by:


alter_table_set_schema_stmt:

ALTER TABLE IF EXISTS relation_expr SET SCHEMA schema_name

referenced by:


alter_table_locality_stmt:

ALTER TABLE IF EXISTS relation_expr SET locality

referenced by:


alter_table_owner_stmt:

ALTER TABLE IF EXISTS relation_expr OWNER TO role_spec

referenced by:


alter_oneindex_stmt:

ALTER INDEX IF EXISTS table_index_name alter_index_cmds

referenced by:


alter_split_index_stmt:

ALTER INDEX table_index_name SPLIT AT select_stmt WITH EXPIRATION a_expr

referenced by:


alter_unsplit_index_stmt:

ALTER INDEX table_index_name UNSPLIT AT select_stmt ALL

referenced by:


alter_scatter_index_stmt:

ALTER INDEX table_index_name SCATTER FROM ( expr_list ) TO ( expr_list )

referenced by:


alter_rename_index_stmt:

ALTER INDEX IF EXISTS table_index_name RENAME TO index_name

referenced by:


alter_zone_index_stmt:

ALTER INDEX table_index_name set_zone_config

referenced by:


alter_index_visible_stmt:

ALTER INDEX IF EXISTS table_index_name alter_index_visible

referenced by:


alter_rename_view_stmt:

ALTER MATERIALIZED VIEW IF EXISTS relation_expr RENAME TO view_name

referenced by:


alter_view_set_schema_stmt:

ALTER MATERIALIZED VIEW IF EXISTS relation_expr SET SCHEMA schema_name

referenced by:


alter_view_owner_stmt:

ALTER MATERIALIZED VIEW IF EXISTS relation_expr OWNER TO role_spec

referenced by:


alter_rename_sequence_stmt:

ALTER SEQUENCE IF EXISTS relation_expr RENAME TO sequence_name

referenced by:


alter_sequence_options_stmt:

ALTER SEQUENCE IF EXISTS sequence_name sequence_option_list

referenced by:


alter_sequence_set_schema_stmt:

ALTER SEQUENCE IF EXISTS relation_expr SET SCHEMA schema_name

referenced by:


alter_sequence_owner_stmt:

ALTER SEQUENCE IF EXISTS relation_expr OWNER TO role_spec

referenced by:


alter_rename_database_stmt:

ALTER DATABASE database_name RENAME TO database_name

referenced by:


alter_zone_database_stmt:

ALTER DATABASE database_name set_zone_config

referenced by:


alter_database_owner:

ALTER DATABASE database_name OWNER TO role_spec

referenced by:


alter_database_to_schema_stmt:

ALTER DATABASE database_name CONVERT TO SCHEMA WITH PARENT database_name

referenced by:


alter_database_add_region_stmt:

ALTER DATABASE database_name ADD REGION IF NOT EXISTS region_name

referenced by:


alter_database_drop_region_stmt:

ALTER DATABASE database_name DROP REGION IF EXISTS region_name

referenced by:


alter_database_survival_goal_stmt:

ALTER DATABASE database_name survival_goal_clause

referenced by:


alter_database_primary_region_stmt:

ALTER DATABASE database_name SET primary_region_clause

referenced by:


alter_database_placement_stmt:

ALTER DATABASE database_name placement_clause

referenced by:


alter_database_set_stmt:

ALTER DATABASE database_name set_or_reset_clause

referenced by:


alter_database_add_super_region:

ALTER DATABASE database_name ADD SUPER REGION region_name VALUES region_name_list

referenced by:


alter_database_alter_super_region:

ALTER DATABASE database_name ALTER SUPER REGION region_name VALUES region_name_list

referenced by:


alter_database_drop_super_region:

ALTER DATABASE database_name DROP SUPER REGION region_name

referenced by:


alter_database_set_secondary_region_stmt:

ALTER DATABASE database_name SET secondary_region_clause

referenced by:


alter_database_drop_secondary_region:

ALTER DATABASE database_name DROP SECONDARY REGION IF EXISTS

referenced by:


alter_database_set_zone_config_extension_stmt:

ALTER DATABASE database_name ALTER LOCALITY GLOBAL REGIONAL IN region_name set_zone_config

referenced by:


alter_zone_range_stmt:

ALTER RANGE a_expr set_zone_config

referenced by:


alter_range_relocate_stmt:

ALTER RANGE relocate_kw LEASE relocate_subject_nonlease FROM a_expr TO a_expr FOR select_stmt a_expr relocate_kw LEASE relocate_subject_nonlease FROM a_expr TO a_expr

referenced by:


alter_zone_partition_stmt:

ALTER PARTITION partition_name OF TABLE table_name INDEX table_index_name table_name @ * set_zone_config

referenced by:


schema_name:

name

referenced by:


opt_add_val_placement:

BEFORE AFTER SCONST

referenced by:


opt_in_schemas:

IN SCHEMA schema_name_list

referenced by:


abbreviated_grant_stmt:

GRANT privileges ON target_object_type TO role_spec_list opt_with_grant_option

referenced by:


abbreviated_revoke_stmt:

REVOKE GRANT OPTION FOR privileges ON target_object_type FROM role_spec_list opt_drop_behavior

referenced by:


alter_changefeed_cmds:

alter_changefeed_cmd

referenced by:


alter_backup_cmds:

alter_backup_cmd

referenced by:


alter_func_options_stmt:

ALTER FUNCTION function_with_paramtypes alter_func_opt_list opt_restrict

referenced by:


alter_func_rename_stmt:

ALTER FUNCTION function_with_paramtypes RENAME TO name

referenced by:


alter_func_owner_stmt:

ALTER FUNCTION function_with_paramtypes OWNER TO role_spec

referenced by:


alter_func_set_schema_stmt:

ALTER FUNCTION function_with_paramtypes SET SCHEMA schema_name

referenced by:


alter_func_dep_extension_stmt:

ALTER FUNCTION function_with_paramtypes opt_no DEPENDS ON EXTENSION name

referenced by:


alter_proc_rename_stmt:

ALTER PROCEDURE function_with_paramtypes RENAME TO name

referenced by:


alter_proc_owner_stmt:

ALTER PROCEDURE function_with_paramtypes OWNER TO role_spec

referenced by:


alter_proc_set_schema_stmt:

ALTER PROCEDURE function_with_paramtypes SET SCHEMA schema_name

referenced by:


alter_backup_schedule_cmds:

alter_backup_schedule_cmd ,

referenced by:


role_options:

role_option

referenced by:


backup_options:

ENCRYPTION_PASSPHRASE EXECUTION LOCALITY = string_or_placeholder REVISION_HISTORY UPDATES_CLUSTER_MONITORING_METRICS = a_expr DETACHED = TRUE FALSE KMS INCREMENTAL_LOCATION = string_or_placeholder_opt_list INCLUDE_ALL_VIRTUAL_CLUSTERS = a_expr

referenced by:


c_expr:

d_expr array_subscripts case_expr EXISTS select_with_parens

referenced by:


qual_op:

OPERATOR ( operator_op )

referenced by:


row:

ROW ( opt_expr_list ) expr_tuple_unambiguous

referenced by:


cast_target:

typename

referenced by:


collation_name:

unrestricted_name

referenced by:


opt_asymmetric:

ASYMMETRIC

referenced by:


b_expr:

c_expr + - ~ qual_op b_expr TYPECAST cast_target TYPEANNOTATE typename + - * / FLOORDIV % ^ # & | < > = CONCAT LSHIFT RSHIFT LESS_EQUALS GREATER_EQUALS NOT_EQUALS qual_op b_expr IS NOT DISTINCT FROM b_expr OF ( type_list )

referenced by:


in_expr:

select_with_parens expr_tuple1_ambiguous

referenced by:


subquery_op:

all_op qual_op NOT LIKE ILIKE

referenced by:


sub_type:

ANY SOME ALL

referenced by:


opt_template_clause:

TEMPLATE opt_equal non_reserved_word_or_sconst

referenced by:


opt_encoding_clause:

ENCODING opt_equal non_reserved_word_or_sconst

referenced by:


opt_lc_collate_clause:

LC_COLLATE opt_equal non_reserved_word_or_sconst

referenced by:


opt_lc_ctype_clause:

LC_CTYPE opt_equal non_reserved_word_or_sconst

referenced by:


opt_connection_limit:

CONNECTION LIMIT opt_equal signed_iconst

referenced by:


opt_primary_region_clause:

primary_region_clause

referenced by:


opt_regions_list:

REGIONS opt_equal region_name_list

referenced by:


opt_survival_goal_clause:

survival_goal_clause

referenced by:


opt_placement_clause:

placement_clause

referenced by:


opt_owner_clause:

OWNER opt_equal role_spec

referenced by:


opt_super_region_clause:

super_region_clause

referenced by:


opt_secondary_region_clause:

secondary_region_clause

referenced by:


opt_unique:

UNIQUE

referenced by:


opt_index_name:

opt_name

referenced by:


opt_index_access_method:

USING name

referenced by:


index_params:

index_elem ,

referenced by:


opt_hash_sharded:

USING HASH opt_hash_sharded_bucket_count

referenced by:


opt_storing:

storing ( name_list )

referenced by:


opt_partition_by_index:

partition_by

referenced by:


opt_with_storage_parameter_list:

WITH ( storage_parameter_list )

referenced by:


opt_index_visible:

NOT VISIBLE INVISIBLE VISIBILITY FCONST

referenced by:


opt_schema_name:

qualifiable_schema_name

referenced by:


opt_persistence_temp_table:

opt_temp LOCAL GLOBAL TEMPORARY TEMP UNLOGGED

referenced by:


opt_table_elem_list:

table_elem_list

referenced by:


opt_partition_by_table:

partition_by_table

referenced by:


opt_table_with:

opt_with_storage_parameter_list

referenced by:


opt_create_table_on_commit:

ON COMMIT PRESERVE ROWS

referenced by:


opt_locality:

locality

referenced by:


create_as_opt_col_list:

( create_as_table_defs )

referenced by:


opt_enum_val_list:

enum_val_list

referenced by:


opt_composite_type_list:

composite_type_list

referenced by:


opt_temp:

TEMPORARY TEMP

referenced by:


opt_with_data:

WITH DATA

referenced by:


sequence_name:

db_object_name

referenced by:


opt_sequence_option_list:

sequence_option_list

referenced by:


opt_or_replace:

OR REPLACE

referenced by:


routine_create_name:

db_object_name

referenced by:


opt_routine_param_with_default_list:

routine_param_with_default_list

referenced by:


opt_return_set:

SETOF

referenced by:


routine_return_type:

routine_param_type

referenced by:


opt_create_routine_opt_list:

create_routine_opt_list

referenced by:


opt_routine_body:

routine_return_stmt BEGIN ATOMIC routine_body_stmt_list END

referenced by:


trigger_action_time:

BEFORE AFTER INSTEAD OF

referenced by:


trigger_event_list:

trigger_event OR

referenced by:


opt_trigger_transition_list:

REFERENCING trigger_transition_list

referenced by:


trigger_for_each:

FOR trigger_for_opt_each trigger_for_type

referenced by:


trigger_when:

WHEN a_expr

referenced by:


function_or_procedure:

FUNCTION PROCEDURE

referenced by:


trigger_func_args:

trigger_func_arg , trigger_func_arg

referenced by:


create_stats_option_list:

create_stats_option

referenced by:


changefeed_target:

opt_table_prefix table_name opt_changefeed_family

referenced by:


target_elem:

a_expr AS target_name bare_col_label *

referenced by:


schedule_label_spec:

label_spec

referenced by:


changefeed_sink:

INTO string_or_placeholder

referenced by:


cron_expr:

RECURRING sconst_or_placeholder

referenced by:


opt_with_schedule_options:

WITH SCHEDULE OPTIONS kv_option_list ( kv_option_list )

referenced by:


opt_full_backup_clause:

FULL BACKUP sconst_or_placeholder ALWAYS

referenced by:


cte_list:

common_table_expr ,

referenced by:


batch_param:

SIZE a_expr

referenced by:


opt_only:

ONLY

referenced by:


opt_index_flags:

@ index_name [ ICONST ] { index_flags_param_list }

referenced by:


opt_descendant:

*

referenced by:


table_ref:

relation_expr opt_index_flags select_with_parens [ row_source_extension_stmt ] LATERAL select_with_parens func_table opt_ordinality opt_alias_clause joined_table ( joined_table ) opt_ordinality alias_clause func_table opt_ordinality opt_func_alias_clause

referenced by:


sortby_list:

sortby sortby_index ,

referenced by:


first_or_next:

FIRST NEXT

referenced by:


select_fetch_first_value:

c_expr only_signed_iconst only_signed_fconst

referenced by:


row_or_rows:

ROW ROWS

referenced by:


table_index_name_list:

table_index_name ,

referenced by:


table_name_list:

db_object_name_list

referenced by:


view_name_list:

db_object_name_list

referenced by:


sequence_name_list:

db_object_name_list

referenced by:


non_reserved_word:

identifier unreserved_keyword col_name_keyword type_func_name_keyword

referenced by:


kv_option:

name SCONST = string_or_placeholder

referenced by:


column_name:

name

referenced by:


session_var_parts:

. identifier

referenced by:


attrs:

. unrestricted_name

referenced by:


restore_options:

ENCRYPTION_PASSPHRASE INTO_DB NEW_DB_NAME VIRTUAL_CLUSTER_NAME VIRTUAL_CLUSTER EXECUTION LOCALITY = string_or_placeholder KMS INCREMENTAL_LOCATION = string_or_placeholder_opt_list SKIP_MISSING_FOREIGN_KEYS SKIP_MISSING_SEQUENCES SKIP_MISSING_SEQUENCE_OWNERS SKIP_MISSING_VIEWS SKIP_MISSING_UDFS DETACHED SKIP_LOCALITIES_CHECK SCHEMA_ONLY VERIFY_BACKUP_TABLE_DATA UNSAFE_RESTORE_INCOMPATIBLE_VERSION EXPERIMENTAL DEFERRED COPY REMOVE_REGIONS

referenced by:


scrub_option_list:

scrub_option ,

referenced by:


simple_select_clause:

SELECT opt_all_clause opt_target_list DISTINCT distinct_on_clause target_list from_clause opt_where_clause group_clause having_clause window_clause

referenced by:


values_clause:

VALUES ( expr_list ) ,

referenced by:


table_clause:

TABLE table_ref

referenced by:


set_operation:

select_clause UNION INTERSECT EXCEPT all_or_distinct select_clause

referenced by:


for_locking_items:

for_locking_item

referenced by:


offset_clause:

OFFSET a_expr select_fetch_first_value row_or_rows

referenced by:


generic_set:

var_name to_or_eq var_list

referenced by:


extra_var_value:

ON NONE cockroachdb_extra_reserved_keyword

referenced by:


show_backup_options_list:

show_backup_options ,

referenced by:


targets_roles:

ROLE role_spec_list SCHEMA schema_name_list schema_wildcard TYPE type_name_list grant_targets

referenced by:


show_job_options:

EXECUTION DETAILS

referenced by:


show_ranges_options:

TABLES INDEXES DETAILS KEYS EXPLAIN , TABLES INDEXES DETAILS EXPLAIN KEYS

referenced by:


partition:

PARTITION partition_name

referenced by:


single_set_clause:

column_name = a_expr

referenced by:


multiple_set_clause:

( insert_column_list ) = in_expr

referenced by:


type_function_name:

identifier unreserved_keyword type_func_name_keyword

referenced by:


sortby_no_index_list:

sortby , sortby sortby_index

referenced by:


cockroachdb_extra_reserved_keyword:

INDEX NOTHING

referenced by:


type_func_name_keyword:

type_func_name_no_crdb_extra_keyword FAMILY

referenced by:


reserved_keyword:

ALL ANALYSE ANALYZE AND ANY ARRAY AS ASC ASYMMETRIC BOTH CASE CAST CHECK COLLATE COLUMN CONCURRENTLY CONSTRAINT CREATE CURRENT_CATALOG CURRENT_DATE CURRENT_ROLE CURRENT_SCHEMA CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER DEFAULT DEFERRABLE DESC DISTINCT DO ELSE END EXCEPT FALSE FETCH FOR FOREIGN FROM GRANT GROUP HAVING IN INITIALLY INTERSECT INTO LATERAL LEADING LIMIT LOCALTIME LOCALTIMESTAMP NOT NULL OFFSET ON ONLY OR ORDER PLACING PRIMARY REFERENCES RETURNING SELECT SESSION_USER SOME SYMMETRIC TABLE THEN TO TRAILING TRUE UNION UNIQUE USER USING VARIADIC WHEN WHERE WINDOW WITH cockroachdb_extra_reserved_keyword

referenced by:


func_params:

( func_params_list )

referenced by:


simple_typename:

general_type_name @ ICONST complex_type_name const_typename interval_type

referenced by:


opt_array_bounds:

[ ]

referenced by:


transaction_user_priority:

PRIORITY user_priority

referenced by:


transaction_read_mode:

READ ONLY WRITE

referenced by:


transaction_deferrable_mode:

NOT DEFERRABLE

referenced by:


only_signed_iconst:

+ - ICONST

referenced by:


alter_table_cmds:

alter_table_cmd ,

referenced by:


set_zone_config:

CONFIGURE ZONE USING var_set_list DISCARD

referenced by:


locality:

LOCALITY GLOBAL REGIONAL BY TABLE IN region_name PRIMARY REGION ROW AS name IN region_name PRIMARY REGION

referenced by:


alter_index_cmds:

alter_index_cmd ,

referenced by:


alter_index_visible:

NOT VISIBLE INVISIBLE VISIBILITY FCONST

referenced by:


sequence_option_list:

sequence_option_elem

referenced by:


region_name:

name SCONST

referenced by:


survival_goal_clause:

SURVIVE opt_equal REGION ZONE FAILURE

referenced by:


primary_region_clause:

PRIMARY REGION opt_equal region_name

referenced by:


placement_clause:

PLACEMENT RESTRICTED DEFAULT

referenced by:


region_name_list:

region_name ,

referenced by:


secondary_region_clause:

SECONDARY REGION opt_equal region_name

referenced by:


relocate_kw:

TESTING_RELOCATE EXPERIMENTAL_RELOCATE RELOCATE

referenced by:


relocate_subject_nonlease:

VOTERS NONVOTERS

referenced by:


target_object_type:

TABLES SEQUENCES TYPES SCHEMAS FUNCTIONS

referenced by:


alter_changefeed_cmd:

ADD changefeed_targets opt_with_options DROP changefeed_targets SET kv_option_list UNSET name_list

referenced by:


alter_backup_cmd:

ADD backup_kms

referenced by:


alter_func_opt_list:

common_routine_opt_item

referenced by:


opt_restrict:

RESTRICT

referenced by:


opt_no:

NO

referenced by:


alter_backup_schedule_cmd:

SET LABEL string_or_placeholder INTO string_or_placeholder_opt_list WITH backup_options cron_expr FULL BACKUP ALWAYS sconst_or_placeholder SCHEDULE OPTION kv_option EXECUTE FULL IMMEDIATELY

referenced by:


role_option:

CREATEROLE NOCREATEROLE LOGIN NOLOGIN CONTROLJOB NOCONTROLJOB CONTROLCHANGEFEED NOCONTROLCHANGEFEED CREATEDB NOCREATEDB CREATELOGIN NOCREATELOGIN VIEWACTIVITY NOVIEWACTIVITY VIEWACTIVITYREDACTED NOVIEWACTIVITYREDACTED CANCELQUERY NOCANCELQUERY MODIFYCLUSTERSETTING NOMODIFYCLUSTERSETTING SQLLOGIN NOSQLLOGIN VIEWCLUSTERSETTING NOVIEWCLUSTERSETTING password_clause valid_until_clause subject_clause REPLICATION NOREPLICATION

referenced by:


d_expr:

@ ICONST FCONST SCONST BCONST BITCONST typed_literal interval_value TRUE FALSE NULL column_path_with_star PLACEHOLDER ( a_expr ) . * unrestricted_name @ ICONST func_expr select_with_parens labeled_row ARRAY select_with_parens row array_expr

referenced by:


array_subscripts:

array_subscript

referenced by:


case_expr:

CASE case_arg when_clause_list case_default END

referenced by:


operator_op:

all_op

referenced by:


opt_expr_list:

expr_list

referenced by:


expr_tuple_unambiguous:

( tuple1_unambiguous_values )

referenced by:


expr_tuple1_ambiguous:

( tuple1_ambiguous_values )

referenced by:


all_op:

+ - * / % ^ < > = LESS_EQUALS GREATER_EQUALS NOT_EQUALS ? & | # FLOORDIV CONTAINS CONTAINED_BY LSHIFT RSHIFT CONCAT FETCHVAL FETCHTEXT FETCHVAL_PATH FETCHTEXT_PATH JSON_SOME_EXISTS JSON_ALL_EXISTS NOT_REGMATCH REGIMATCH NOT_REGIMATCH AND_AND AT_AT DISTANCE COS_DISTANCE NEG_INNER_PRODUCT ~ SQRT CBRT

referenced by:


opt_equal:

=

referenced by:


super_region_clause:

SUPER REGION region_name VALUES region_name_list

referenced by:


opt_name:

name

referenced by:


index_elem:

func_expr_windowless ( a_expr ) name index_elem_options

referenced by:


opt_hash_sharded_bucket_count:

WITH BUCKET_COUNT = a_expr

referenced by:


storing:

COVERING STORING INCLUDE

referenced by:


partition_by:

PARTITION BY partition_by_inner

referenced by:


storage_parameter_list:

storage_parameter ,

referenced by:


table_elem_list:

table_elem ,

referenced by:


partition_by_table:

partition_by PARTITION ALL BY partition_by_inner

referenced by:


create_as_table_defs:

column_name create_as_col_qual_list , column_name create_as_col_qual_list family_def create_as_constraint_def

referenced by:


enum_val_list:

SCONST ,

referenced by:


composite_type_list:

name simple_typename ,

referenced by:


routine_param_with_default_list:

routine_param_with_default ,

referenced by:


routine_param_type:

typename

referenced by:


create_routine_opt_list:

create_routine_opt_item

referenced by:


routine_return_stmt:

RETURN a_expr

referenced by:


routine_body_stmt_list:

routine_body_stmt ;

referenced by:


trigger_event:

INSERT DELETE UPDATE OF name_list TRUNCATE

referenced by:


trigger_transition_list:

trigger_transition

referenced by:


trigger_for_opt_each:

EACH

referenced by:


trigger_for_type:

ROW STATEMENT

referenced by:


trigger_func_arg:

ICONST FCONST SCONST unrestricted_name

referenced by:


create_stats_option:

as_of_clause USING EXTREMES where_clause

referenced by:


opt_table_prefix:

TABLE

referenced by:


opt_changefeed_family:

FAMILY family_name

referenced by:


target_name:

unrestricted_name

referenced by:


bare_col_label:

identifier bare_label_keywords

referenced by:


common_table_expr:

table_alias_name opt_col_def_list_no_types AS materialize_clause ( preparable_stmt )

referenced by:


index_flags_param_list:

index_flags_param ,

referenced by:


opt_ordinality:

WITH ORDINALITY

referenced by:


opt_alias_clause:

alias_clause

referenced by:


joined_table:

( joined_table ) table_ref CROSS opt_join_hint NATURAL join_type opt_join_hint JOIN table_ref join_type opt_join_hint JOIN table_ref join_qual

referenced by:


alias_clause:

AS table_alias_name opt_col_def_list_no_types

referenced by:


func_table:

func_expr_windowless ROWS FROM ( rowsfrom_list )

referenced by:


opt_func_alias_clause:

func_alias_clause

referenced by:


row_source_extension_stmt:

delete_stmt explain_stmt insert_stmt select_stmt show_stmt update_stmt upsert_stmt

referenced by:


sortby:

a_expr opt_asc_desc opt_nulls_order

referenced by:


sortby_index:

PRIMARY KEY table_name INDEX table_name @ index_name opt_asc_desc

referenced by:


only_signed_fconst:

+ - FCONST

referenced by:


db_object_name_list:

db_object_name ,

referenced by:


scrub_option:

INDEX CONSTRAINT ALL ( name_list ) PHYSICAL

referenced by:


opt_all_clause:

ALL

referenced by:


opt_target_list:

target_list

referenced by:


from_clause:

FROM from_list opt_as_of_clause

referenced by:


group_clause:

GROUP BY group_by_list

referenced by:


having_clause:

HAVING a_expr

referenced by:


window_clause:

WINDOW window_definition_list

referenced by:


distinct_on_clause:

DISTINCT ON ( expr_list )

referenced by:


all_or_distinct:

ALL DISTINCT

referenced by:


for_locking_item:

for_locking_strength opt_locked_rels opt_nowait_or_skip

referenced by:


var_list:

var_value ,

referenced by:


show_backup_options:

AS_JSON CHECK_FILES SKIP SIZE DEBUG_IDS INCREMENTAL_LOCATION KMS = string_or_placeholder_opt_list ENCRYPTION_PASSPHRASE ENCRYPTION_INFO_DIR = string_or_placeholder PRIVILEGES DEBUG_DUMP_METADATA_SST

referenced by:


schema_wildcard:

wildcard_pattern

referenced by:


type_func_name_no_crdb_extra_keyword:

AUTHORIZATION COLLATION CROSS FULL INNER ILIKE IS ISNULL JOIN LEFT LIKE NATURAL NONE NOTNULL OUTER OVERLAPS RIGHT SIMILAR

referenced by:


func_params_list:

routine_param ,

referenced by:


general_type_name:

type_function_name_no_crdb_extra

referenced by:


complex_type_name:

general_type_name . unrestricted_name . unrestricted_name

referenced by:


const_typename:

numeric bit_without_length bit_with_length character_without_length character_with_length const_datetime const_geo const_vector

referenced by:


interval_type:

INTERVAL interval_qualifier ( ICONST )

referenced by:


user_priority:

LOW NORMAL HIGH

referenced by:


alter_table_cmd:

RENAME opt_column CONSTRAINT column_name TO column_name ADD COLUMN IF NOT EXISTS column_table_def table_constraint CONSTRAINT IF NOT EXISTS constraint_name constraint_elem opt_validate_behavior ALTER opt_column column_name alter_column_default alter_column_on_update alter_column_visible DROP NOT NULL IDENTITY IF EXISTS STORED ADD generated_always_as generated_by_default_as IDENTITY ( opt_sequence_option_list ) set_generated_always set_generated_default identity_option_list SET NOT NULL opt_set_data TYPE typename opt_collate opt_alter_column_using PRIMARY KEY USING COLUMNS ( index_params ) opt_hash_sharded opt_with_storage_parameter_list DROP opt_column IF EXISTS column_name CONSTRAINT IF EXISTS constraint_name opt_drop_behavior VALIDATE CONSTRAINT constraint_name EXPERIMENTAL_AUDIT SET audit_mode partition_by_table SET ( storage_parameter_list RESET ( storage_parameter_key_list )

referenced by:


var_set_list:

var_name = COPY FROM PARENT var_value , var_name = var_value COPY FROM PARENT

referenced by:


alter_index_cmd:

partition_by_index

referenced by:


sequence_option_elem:

AS typename NO CYCLE MINVALUE MAXVALUE OWNED BY NONE column_path PER NODE CACHE MINVALUE MAXVALUE INCREMENT BY START WITH signed_iconst64 RESTART WITH signed_iconst64 VIRTUAL

referenced by:


backup_kms:

NEW_KMS = string_or_placeholder_opt_list WITH OLD_KMS = string_or_placeholder_opt_list

referenced by:


common_routine_opt_item:

CALLED RETURNS NULL ON NULL INPUT STRICT IMMUTABLE STABLE VOLATILE EXTERNAL SECURITY DEFINER INVOKER NOT LEAKPROOF

referenced by:


password_clause:

PASSWORD sconst_or_placeholder NULL

referenced by:


valid_until_clause:

VALID UNTIL string_or_placeholder NULL

referenced by:


subject_clause:

SUBJECT string_or_placeholder NULL

referenced by:


typed_literal:

func_name_no_crdb_extra const_typename SCONST

referenced by:


interval_value:

INTERVAL SCONST opt_interval_qualifier ( ICONST ) SCONST

referenced by:


column_path_with_star:

column_path db_object_name_component . unrestricted_name . unrestricted_name . *

referenced by:


func_expr:

func_application within_group_clause filter_clause over_clause func_expr_common_subexpr

referenced by:


labeled_row:

row ( row AS name_list )

referenced by:


array_expr:

[ opt_expr_list array_expr_list ]

referenced by:


array_subscript:

[ a_expr opt_slice_bound : opt_slice_bound ]

referenced by:


case_arg:

a_expr

referenced by:


when_clause_list:

when_clause

referenced by:


case_default:

ELSE a_expr

referenced by:


tuple1_unambiguous_values:

a_expr , expr_list

referenced by:


tuple1_ambiguous_values:

a_expr , expr_list

referenced by:


func_expr_windowless:

func_application func_expr_common_subexpr

referenced by:


index_elem_options:

opt_class opt_asc_desc opt_nulls_order

referenced by:


partition_by_inner:

LIST ( name_list ) ( list_partitions RANGE ( name_list ) ( range_partitions ) NOTHING

referenced by:


storage_parameter:

storage_parameter_key = var_value

referenced by:


table_elem:

column_table_def index_def family_def table_constraint opt_validate_behavior LIKE table_name like_table_option_list

referenced by:


create_as_col_qual_list:

create_as_col_qualification

referenced by:


family_def:

FAMILY opt_family_name ( name_list )

referenced by:


create_as_constraint_def:

create_as_constraint_elem

referenced by:


routine_param_with_default:

routine_param DEFAULT = a_expr

referenced by:


create_routine_opt_item:

AS SCONST opt_link_sym LANGUAGE non_reserved_word_or_sconst common_routine_opt_item

referenced by:


routine_body_stmt:

stmt_without_legacy_transaction routine_return_stmt

referenced by:


trigger_transition:

transition_is_new transition_is_row opt_as table_alias_name

referenced by:


family_name:

name

referenced by:


bare_label_keywords:

ABORT ABSOLUTE ACCESS ACTION ADD ADMIN AFTER AGGREGATE ALL ALTER ALWAYS ANALYSE ANALYZE AND ANNOTATE_TYPE ANY ASC ASENSITIVE ASYMMETRIC AS_JSON AT ATOMIC ATTRIBUTE AUTHORIZATION AUTOMATIC AVAILABILITY BACKUP BACKUPS BACKWARD BATCH BEFORE BEGIN BETWEEN BIGINT BINARY BIT BOOLEAN BOTH BOX2D BUCKET_COUNT BUNDLE BY CACHE CALL CALLED CANCEL CANCELQUERY CAPABILITIES CAPABILITY CASCADE CASE CAST CHANGEFEED CHARACTERISTICS CHECK CHECK_FILES CLOSE CLUSTER CLUSTERS COALESCE COLLATION COLUMN COLUMNS COMMENT COMMENTS COMMIT COMMITTED COMPACT COMPLETE COMPLETIONS CONCURRENTLY CONFIGURATION CONFIGURATIONS CONFIGURE CONFLICT CONNECTION CONNECTIONS CONSTRAINT CONSTRAINTS CONTROLCHANGEFEED CONTROLJOB CONVERSION CONVERT COPY COST COVERING CREATEDB CREATELOGIN CREATEROLE CROSS CSV CUBE CURRENT CURRENT_CATALOG CURRENT_DATE CURRENT_ROLE CURRENT_SCHEMA CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CYCLE DATA DATABASE DATABASES DEALLOCATE DEBUG_DUMP_METADATA_SST DEBUG_IDS DEC DECIMAL DECLARE DEFAULT DEFAULTS DEFERRABLE DEFERRED DEFINER DELETE DELIMITER DEPENDS DESC DESTINATION DETACHED DETAILS DISCARD DISTINCT DO DOMAIN DOUBLE DROP EACH ELSE ENCODING ENCRYPTED ENCRYPTION_INFO_DIR ENCRYPTION_PASSPHRASE END ENUM ENUMS ESCAPE EXCLUDE EXCLUDING EXECUTE EXECUTION EXISTS EXPERIMENTAL EXPERIMENTAL_AUDIT EXPERIMENTAL_FINGERPRINTS EXPERIMENTAL_RELOCATE EXPERIMENTAL_REPLICA EXPIRATION EXPLAIN EXPORT EXTENSION EXTERNAL EXTRACT EXTRACT_DURATION EXTREMES FAILURE FALSE FAMILY FILES FIRST FLOAT FOLLOWING FORCE FORCE_NOT_NULL FORCE_NULL FORCE_QUOTE FORCE_INDEX FORCE_INVERTED_INDEX FORCE_ZIGZAG FOREIGN FORMAT FORWARD FREEZE FULL FUNCTION FUNCTIONS GENERATED GEOGRAPHY GEOMETRY GEOMETRYCOLLECTION GEOMETRYCOLLECTIONM GEOMETRYCOLLECTIONZ GEOMETRYCOLLECTIONZM GEOMETRYM GEOMETRYZ GEOMETRYZM GLOBAL GOAL GRANTEE GRANTS GREATEST GROUPING GROUPS HASH HEADER HIGH HISTOGRAM HOLD IDENTITY IF IFERROR IFNULL IGNORE_FOREIGN_KEYS ILIKE IMMEDIATE IMMEDIATELY IMMUTABLE IMPORT IN INCLUDE INCLUDE_ALL_SECONDARY_TENANTS INCLUDE_ALL_VIRTUAL_CLUSTERS INCLUDING INCREMENT INCREMENTAL INCREMENTAL_LOCATION INDEX INDEXES INDEX INDEX INDEX INHERITS INITIALLY INJECT INNER INOUT INPUT INSENSITIVE INSERT INSTEAD INT INTEGER INTERVAL INTO_DB INVERTED INVISIBLE INVOKER IS ISERROR ISOLATION JOB JOBS JOIN JSON KEY KEYS KMS KV LABEL LANGUAGE LAST LATERAL LATEST LC_COLLATE LC_CTYPE LEADING LEAKPROOF LEASE LEAST LEFT LESS LEVEL LIKE LINESTRING LINESTRINGM LINESTRINGZ LINESTRINGZM LIST LOCAL LOCALITY LOCALTIME LOCALTIMESTAMP LOCKED LOGICAL LOGIN LOOKUP LOW MATCH MATERIALIZED MAXVALUE MERGE METHOD MINVALUE MODE MODIFYCLUSTERSETTING MODIFYSQLCLUSTERSETTING MOVE MULTILINESTRING MULTILINESTRINGM MULTILINESTRINGZ MULTILINESTRINGZM MULTIPOINT MULTIPOINTM MULTIPOINTZ MULTIPOINTZM MULTIPOLYGON MULTIPOLYGONM MULTIPOLYGONZ MULTIPOLYGONZM NAMES NAN NATURAL NEVER NEW NEW_DB_NAME NEW_KMS NEXT NO NOCANCELQUERY NOCONTROLCHANGEFEED NOCONTROLJOB NOCREATEDB NOCREATELOGIN NOCREATEROLE NODE NOLOGIN NOMODIFYCLUSTERSETTING NONE NONVOTERS NORMAL NOREPLICATION NOSQLLOGIN NOT NOTHING NOTHING NOVIEWACTIVITY NOVIEWACTIVITYREDACTED NOVIEWCLUSTERSETTING NOWAIT NO_FULL_SCAN NO_INDEX_JOIN NO_ZIGZAG_JOIN NULL NULLIF NULLS NUMERIC OF OFF OIDS OLD OLD_KMS ONLY OPERATOR OPT OPTION OPTIONS OR ORDINALITY OTHERS OUT OUTER OVERLAY OWNED OWNER PARALLEL PARENT PARTIAL PARTITION PARTITIONS PASSWORD PAUSE PAUSED PER PHYSICAL PLACEMENT PLACING PLAN PLANS POINT POINTM POINTZ POINTZM POLYGON POLYGONM POLYGONZ POLYGONZM POSITION PRECEDING PREPARE PRESERVE PRIMARY PRIOR PRIORITY PRIVILEGES PROCEDURE PROCEDURES PUBLIC PUBLICATION QUERIES QUERY QUOTE RANGE RANGES READ REAL REASON REASSIGN RECURRING RECURSIVE REDACT REF REFERENCES REFERENCING REFRESH REGION REGIONAL REGIONS REINDEX RELATIVE RELEASE RELOCATE REMOVE_REGIONS RENAME REPEATABLE REPLACE REPLICATION RESET RESTART RESTORE RESTRICT RESTRICTED RESUME RETENTION RETRY RETURN RETURNS REVISION_HISTORY REVOKE RIGHT ROLE ROLES ROLLBACK ROLLUP ROUTINES ROW ROWS RULE RUNNING SAVEPOINT SCANS SCATTER SCHEDULE SCHEDULES SCHEMA SCHEMAS SCHEMA_ONLY SCROLL SCRUB SEARCH SECONDARY SECURITY SELECT SEQUENCE SEQUENCES SERIALIZABLE SERVER SERVICE SESSION SESSIONS SESSION_USER SET SETOF SETS SETTING SETTINGS SHARE SHARED SHOW SIMILAR SIMPLE SIZE SKIP SKIP_LOCALITIES_CHECK SKIP_MISSING_FOREIGN_KEYS SKIP_MISSING_SEQUENCES SKIP_MISSING_SEQUENCE_OWNERS SKIP_MISSING_UDFS SKIP_MISSING_VIEWS SMALLINT SNAPSHOT SOME SPLIT SQL SQLLOGIN STABLE START STATE STATEMENT STATEMENTS STATISTICS STATUS STDIN STDOUT STOP STORAGE STORE STORED STORING STRAIGHT STREAM STRICT STRING SUBSCRIPTION SUBSTRING SUBJECT SUPER SUPPORT SURVIVAL SURVIVE SYMMETRIC SYNTAX SYSTEM TABLE TABLES TABLESPACE TEMP TEMPLATE TEMPORARY TENANT TENANTS TENANT_NAME TESTING_RELOCATE TEXT THEN THROTTLING TIES TIME TIMESTAMP TIMESTAMPTZ TIMETZ TRACE TRACING TRAILING TRANSACTION TRANSACTIONS TRANSFER TRANSFORM TREAT TRIGGER TRIM TRUE TRUNCATE TRUSTED TYPE TYPES UNBOUNDED UNCOMMITTED UNIQUE UNKNOWN UNLISTEN UNLOGGED UNSAFE_RESTORE_INCOMPATIBLE_VERSION UNSET UNSPLIT UNTIL UPDATE UPDATES_CLUSTER_MONITORING_METRICS UPSERT USE USER USERS USING VALID VALIDATE VALUE VALUES VARBIT VARCHAR VARIABLES VARIADIC VECTOR VERIFY_BACKUP_TABLE_DATA VIEW VIEWACTIVITY VIEWACTIVITYREDACTED VIEWCLUSTERMETADATA VIEWCLUSTERSETTING VIEWDEBUG VIRTUAL VIRTUAL_CLUSTER_NAME VIRTUAL_CLUSTER VISIBLE VISIBILITY VOLATILE VOTERS WHEN WORK WRITE ZONE

referenced by:


opt_col_def_list_no_types:

( col_def_list_no_types )

referenced by:


materialize_clause:

NOT MATERIALIZED

referenced by:


index_flags_param:

FORCE_INDEX = index_name NO_INDEX_JOIN NO_ZIGZAG_JOIN NO_FULL_SCAN FORCE_ZIGZAG = index_name

referenced by:


opt_join_hint:

HASH MERGE LOOKUP INVERTED STRAIGHT

referenced by:


join_type:

FULL LEFT RIGHT join_outer INNER

referenced by:


join_qual:

USING ( name_list ) ON a_expr

referenced by:


rowsfrom_list:

rowsfrom_item ,

referenced by:


func_alias_clause:

AS table_alias_name opt_col_def_list

referenced by:


opt_asc_desc:

ASC DESC

referenced by:


opt_nulls_order:

NULLS FIRST LAST

referenced by:


group_by_list:

group_by_item ,

referenced by:


window_definition_list:

window_definition ,

referenced by:


for_locking_strength:

FOR NO KEY UPDATE KEY SHARE

referenced by:


opt_locked_rels:

OF table_name_list

referenced by:


opt_nowait_or_skip:

SKIP LOCKED NOWAIT

referenced by:


wildcard_pattern:

name . *

referenced by:


routine_param:

routine_param_class param_name param_name routine_param_class routine_param_type

referenced by:


type_function_name_no_crdb_extra:

identifier unreserved_keyword type_func_name_no_crdb_extra_keyword

referenced by:


numeric:

INT INTEGER SMALLINT BIGINT REAL FLOAT opt_float DOUBLE PRECISION DECIMAL DEC NUMERIC opt_numeric_modifiers BOOLEAN

referenced by:


bit_without_length:

BIT VARYING VARBIT

referenced by:


bit_with_length:

BIT opt_varying VARBIT ( ICONST )

referenced by:


character_without_length:

character_base

referenced by:


character_with_length:

character_base ( ICONST )

referenced by:


const_datetime:

DATE TIME TIMESTAMP ( ICONST ) opt_timezone TIMETZ TIMESTAMPTZ ( ICONST )

referenced by:


const_geo:

GEOGRAPHY GEOMETRY ( geo_shape_type , signed_iconst ) BOX2D

referenced by:


const_vector:

VECTOR ( ICONST )

referenced by:


interval_qualifier:

YEAR TO MONTH MONTH DAY TO HOUR MINUTE interval_second HOUR TO MINUTE interval_second MINUTE TO interval_second interval_second

referenced by:


opt_column:

COLUMN

referenced by:


column_table_def:

column_name typename col_qual_list

referenced by:


alter_column_default:

SET DEFAULT a_expr DROP DEFAULT

referenced by:


alter_column_on_update:

SET ON UPDATE a_expr DROP ON UPDATE

referenced by:


alter_column_visible:

SET NOT VISIBLE

referenced by:


generated_always_as:

GENERATED_ALWAYS ALWAYS AS

referenced by:


generated_by_default_as:

GENERATED_BY_DEFAULT BY DEFAULT AS

referenced by:


set_generated_always:

SET GENERATED_ALWAYS ALWAYS

referenced by:


set_generated_default:

SET GENERATED_BY_DEFAULT BY DEFAULT

referenced by:


identity_option_list:

identity_option_elem

referenced by:


opt_set_data:

SET DATA

referenced by:


opt_collate:

COLLATE collation_name

referenced by:


opt_alter_column_using:

USING a_expr

referenced by:


table_constraint:

CONSTRAINT constraint_name constraint_elem

referenced by:


opt_validate_behavior:

NOT VALID

referenced by:


constraint_elem:

CHECK ( a_expr ) UNIQUE ( index_params ) opt_storing opt_partition_by_index opt_where_clause PRIMARY KEY ( index_params ) opt_hash_sharded opt_with_storage_parameter_list FOREIGN KEY ( name_list ) REFERENCES table_name opt_column_list key_match reference_actions

referenced by:


audit_mode:

READ WRITE OFF

referenced by:


storage_parameter_key_list:

storage_parameter_key ,

referenced by:


partition_by_index:

partition_by

referenced by:


func_name_no_crdb_extra:

type_function_name_no_crdb_extra prefixed_column_path

referenced by:


opt_interval_qualifier:

interval_qualifier

referenced by:


within_group_clause:

WITHIN GROUP ( single_sort_clause )

referenced by:


filter_clause:

FILTER ( WHERE a_expr )

referenced by:


over_clause:

OVER window_specification window_name

referenced by:


func_expr_common_subexpr:

COLLATION FOR ( IF ( a_expr , NULLIF IFNULL ( IFERROR ( a_expr , a_expr , ISERROR ( a_expr , a_expr CAST ( a_expr AS cast_target ANNOTATE_TYPE ( a_expr , typename COALESCE ( expr_list ) CURRENT_DATE CURRENT_SCHEMA CURRENT_CATALOG CURRENT_TIMESTAMP CURRENT_TIME LOCALTIMESTAMP LOCALTIME CURRENT_USER CURRENT_ROLE SESSION_USER USER special_function

referenced by:


array_expr_list:

array_expr ,

referenced by:


opt_slice_bound:

a_expr

referenced by:


when_clause:

WHEN a_expr THEN a_expr

referenced by:


opt_class:

name

referenced by:


list_partitions:

list_partition ,

referenced by:


range_partitions:

range_partition ,

referenced by:


storage_parameter_key:

name SCONST

referenced by:


index_def:

INDEX name UNIQUE INDEX opt_index_name ( index_params ) opt_hash_sharded opt_storing INVERTED INDEX name ( index_params ) opt_partition_by_index opt_with_storage_parameter_list opt_where_clause opt_index_visible

referenced by:


like_table_option_list:

INCLUDING EXCLUDING like_table_option

referenced by:


create_as_col_qualification:

create_as_col_qualification_elem FAMILY family_name

referenced by:


opt_family_name:

opt_name

referenced by:


create_as_constraint_elem:

PRIMARY KEY ( create_as_params ) opt_with_storage_parameter_list

referenced by:


opt_link_sym:

, SCONST

referenced by:


transition_is_new:

NEW OLD

referenced by:


transition_is_row:

ROW TABLE

referenced by:


opt_as:

AS

referenced by:


col_def_list_no_types:

name ,

referenced by:


join_outer:

OUTER

referenced by:


rowsfrom_item:

func_expr_windowless opt_func_alias_clause

referenced by:


opt_col_def_list:

( col_def_list )

referenced by:


group_by_item:

a_expr

referenced by:


window_definition:

window_name AS window_specification

referenced by:


routine_param_class:

IN OUT OUT INOUT

referenced by:


param_name:

type_function_name

referenced by:


opt_float:

( ICONST )

referenced by:


opt_numeric_modifiers:

( ICONST , ICONST )

referenced by:


opt_varying:

VARYING

referenced by:


character_base:

char_aliases VARYING VARCHAR STRING

referenced by:


opt_timezone:

WITH WITHOUT TIME ZONE

referenced by:


geo_shape_type:

POINT POINTM POINTZ POINTZM LINESTRING LINESTRINGM LINESTRINGZ LINESTRINGZM POLYGON POLYGONM POLYGONZ POLYGONZM MULTIPOINT MULTIPOINTM MULTIPOINTZ MULTIPOINTZM MULTILINESTRING MULTILINESTRINGM MULTILINESTRINGZ MULTILINESTRINGZM MULTIPOLYGON MULTIPOLYGONM MULTIPOLYGONZ MULTIPOLYGONZM GEOMETRYCOLLECTION GEOMETRYCOLLECTIONM GEOMETRYCOLLECTIONZ GEOMETRYCOLLECTIONZM GEOMETRY GEOMETRYM GEOMETRYZ GEOMETRYZM

referenced by:


interval_second:

SECOND ( ICONST )

referenced by:


col_qual_list:

col_qualification

referenced by:


identity_option_elem:

SET NO CYCLE MINVALUE MAXVALUE CACHE MINVALUE MAXVALUE INCREMENT BY START WITH signed_iconst64 RESTART WITH signed_iconst64

referenced by:


key_match:

MATCH SIMPLE FULL

referenced by:


reference_actions:

reference_on_update reference_on_delete reference_on_delete reference_on_update

referenced by:


single_sort_clause:

ORDER BY sortby , sortby_list sortby_index , sortby_list

referenced by:


window_specification:

( opt_existing_window_name opt_partition_clause opt_sort_clause_no_index opt_frame_clause )

referenced by:


window_name:

name

referenced by:


special_function:

CURRENT_DATE CURRENT_SCHEMA CURRENT_USER SESSION_USER ( EXTRACT EXTRACT_DURATION ( extract_list OVERLAY ( overlay_list POSITION ( position_list SUBSTRING ( substr_list GREATEST LEAST ( expr_list CURRENT_TIMESTAMP CURRENT_TIME LOCALTIMESTAMP LOCALTIME ( a_expr TRIM ( BOTH LEADING TRAILING trim_list )

referenced by:


list_partition:

partition VALUES IN ( expr_list ) opt_partition_by

referenced by:


range_partition:

partition VALUES FROM ( expr_list ) TO ( expr_list ) opt_partition_by

referenced by:


like_table_option:

CONSTRAINTS DEFAULTS GENERATED INDEXES ALL

referenced by:


create_as_col_qualification_elem:

PRIMARY KEY opt_with_storage_parameter_list

referenced by:


create_as_params:

create_as_param ,

referenced by:


col_def_list:

col_def ,

referenced by:


char_aliases:

CHAR CHARACTER

referenced by:


col_qualification:

CONSTRAINT constraint_name col_qualification_elem COLLATE collation_name FAMILY family_name CREATE FAMILY family_name IF NOT EXISTS FAMILY family_name

referenced by:


reference_on_update:

ON UPDATE reference_action

referenced by:


reference_on_delete:

ON DELETE reference_action

referenced by:


opt_existing_window_name:

name

referenced by:


opt_partition_clause:

PARTITION BY expr_list

referenced by:


opt_frame_clause:

RANGE ROWS GROUPS frame_extent opt_frame_exclusion

referenced by:


extract_list:

extract_arg FROM a_expr expr_list

referenced by:


overlay_list:

a_expr overlay_placing substr_from substr_for expr_list

referenced by:


position_list:

b_expr IN b_expr

referenced by:


substr_list:

a_expr substr_from substr_for substr_for substr_from opt_expr_list

referenced by:


trim_list:

a_expr FROM expr_list

referenced by:


opt_partition_by:

partition_by

referenced by:


create_as_param:

column_name

referenced by:


col_def:

name typename

referenced by:


col_qualification_elem:

NOT NULL VISIBLE NULL UNIQUE PRIMARY KEY USING HASH opt_hash_sharded_bucket_count opt_with_storage_parameter_list CHECK ( a_expr ) DEFAULT ON UPDATE b_expr REFERENCES table_name opt_name_parens key_match reference_actions generated_as ( a_expr ) STORED VIRTUAL generated_always_as generated_by_default_as IDENTITY ( opt_sequence_option_list )

referenced by:


reference_action:

NO ACTION RESTRICT CASCADE SET NULL DEFAULT

referenced by:


frame_extent:

BETWEEN frame_bound AND frame_bound

referenced by:


opt_frame_exclusion:

EXCLUDE CURRENT ROW GROUP TIES NO OTHERS

referenced by:


extract_arg:

identifier YEAR MONTH DAY HOUR MINUTE SECOND SCONST

referenced by:


overlay_placing:

PLACING a_expr

referenced by:


substr_from:

FROM a_expr

referenced by:


substr_for:

FOR a_expr

referenced by:


opt_name_parens:

( name )

referenced by:


generated_as:

AS generated_always_as

referenced by:


frame_bound:

UNBOUNDED a_expr PRECEDING FOLLOWING CURRENT ROW

referenced by:


generated by Railroad Diagram Generator


Yes No