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
stmt:
HELPTOKEN preparable_stmt copy_from_stmt comment_stmt execute_stmt deallocate_stmt discard_stmt export_stmt grant_stmt prepare_stmt revoke_stmt savepoint_stmt release_stmt nonpreparable_set_stmt transaction_stmt
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 scrub_stmt select_stmt preparable_set_stmt show_stmt truncate_stmt update_stmt upsert_stmt
copy_from_stmt:
COPY table_name opt_column_list FROM STDIN
comment_stmt:
COMMENT ON DATABASE database_name TABLE table_name COLUMN column_path IS comment_text
execute_stmt:
EXECUTE table_alias_name execute_param_clause
deallocate_stmt:
DEALLOCATE PREPARE name ALL
discard_stmt:
DISCARD ALL
export_stmt:
EXPORT INTO import_format string_or_placeholder opt_with_options FROM select_stmt
grant_stmt:
GRANT privileges ON targets TO name_list privilege_list TO name_list WITH ADMIN OPTION
prepare_stmt:
PREPARE table_alias_name prep_type_clause AS preparable_stmt
revoke_stmt:
REVOKE privileges ON targets ADMIN OPTION FOR privilege_list FROM name_list
savepoint_stmt:
SAVEPOINT name
release_stmt:
RELEASE savepoint_name
nonpreparable_set_stmt:
set_transaction_stmt
transaction_stmt:
begin_stmt commit_stmt rollback_stmt abort_stmt
alter_stmt:
alter_ddl_stmt alter_user_stmt
backup_stmt:
BACKUP targets TO string_or_placeholder opt_as_of_clause opt_incremental opt_with_options
cancel_stmt:
cancel_jobs_stmt cancel_queries_stmt cancel_sessions_stmt
create_stmt:
create_user_stmt create_role_stmt create_ddl_stmt create_stats_stmt
delete_stmt:
opt_with_clause DELETE FROM table_name_expr_opt_alias_idx opt_where_clause opt_sort_clause opt_limit_clause returning_clause
drop_stmt:
drop_ddl_stmt drop_role_stmt drop_user_stmt
explain_stmt:
EXPLAIN ANALYZE ( explain_option_list ) preparable_stmt
import_stmt:
IMPORT import_format string_or_placeholder TABLE table_name FROM import_format string_or_placeholder CREATE USING string_or_placeholder ( table_elem_list ) import_format DATA ( string_or_placeholder_list ) opt_with_options
insert_stmt:
opt_with_clause INSERT INTO insert_target insert_rest on_conflict returning_clause
pause_stmt:
PAUSE JOB a_expr JOBS select_stmt
reset_stmt:
reset_session_stmt reset_csetting_stmt
restore_stmt:
RESTORE targets FROM string_or_placeholder_list as_of_clause opt_with_options
resume_stmt:
RESUME JOB a_expr JOBS select_stmt
scrub_stmt:
scrub_table_stmt scrub_database_stmt
select_stmt:
select_no_parens select_with_parens
preparable_set_stmt:
set_session_stmt set_csetting_stmt use_stmt
show_stmt:
show_backup_stmt show_columns_stmt show_constraints_stmt show_create_stmt show_csettings_stmt show_databases_stmt show_grants_stmt show_indexes_stmt show_jobs_stmt show_queries_stmt show_ranges_stmt show_roles_stmt show_schemas_stmt show_sequences_stmt show_session_stmt show_sessions_stmt show_stats_stmt show_tables_stmt show_trace_stmt show_users_stmt show_zone_stmt
truncate_stmt:
TRUNCATE opt_table relation_expr_list opt_drop_behavior
update_stmt:
opt_with_clause UPDATE table_name_expr_opt_alias_idx SET set_clause_list opt_where_clause opt_sort_clause opt_limit_clause returning_clause
upsert_stmt:
opt_with_clause UPSERT INTO insert_target insert_rest returning_clause
table_name:
db_object_name
opt_column_list:
( name_list )
database_name:
name
comment_text:
SCONST NULL
column_path:
name prefixed_column_path
table_alias_name:
name
execute_param_clause:
( expr_list )
name:
identifier unreserved_keyword col_name_keyword
import_format:
name
string_or_placeholder:
non_reserved_word_or_sconst PLACEHOLDER
opt_with_options:
WITH kv_option_list OPTIONS ( kv_option_list )
privileges:
ALL privilege_list
targets:
identifier col_name_keyword unreserved_keyword complex_table_pattern table_pattern , TABLE table_pattern_list DATABASE name_list
name_list:
name ,
privilege_list:
privilege ,
prep_type_clause:
( type_list )
savepoint_name:
SAVEPOINT name
set_transaction_stmt:
SET SESSION TRANSACTION transaction_mode_list
begin_stmt:
BEGIN opt_transaction START TRANSACTION begin_transaction
commit_stmt:
COMMIT END opt_transaction
rollback_stmt:
ROLLBACK opt_to_savepoint
abort_stmt:
ABORT opt_abort_mod
alter_ddl_stmt:
alter_table_stmt alter_index_stmt alter_view_stmt alter_sequence_stmt alter_database_stmt alter_range_stmt
alter_user_stmt:
alter_user_password_stmt
opt_as_of_clause:
as_of_clause
opt_incremental:
INCREMENTAL FROM string_or_placeholder_list
cancel_jobs_stmt:
CANCEL JOB a_expr JOBS select_stmt
cancel_queries_stmt:
CANCEL QUERY IF EXISTS a_expr QUERIES IF EXISTS select_stmt
cancel_sessions_stmt:
CANCEL SESSION IF EXISTS a_expr SESSIONS IF EXISTS select_stmt
create_user_stmt:
CREATE USER IF NOT EXISTS string_or_placeholder opt_password
create_role_stmt:
CREATE ROLE IF NOT EXISTS string_or_placeholder
create_ddl_stmt:
create_changefeed_stmt create_database_stmt create_index_stmt create_table_stmt create_table_as_stmt create_view_stmt create_sequence_stmt
create_stats_stmt:
CREATE STATISTICS statistics_name opt_stats_columns FROM create_stats_target opt_create_stats_options
opt_with_clause:
with_clause
table_name_expr_opt_alias_idx:
table_name_expr_with_index AS table_alias_name
opt_where_clause:
where_clause
opt_sort_clause:
sort_clause
opt_limit_clause:
limit_clause
returning_clause:
RETURNING target_list NOTHING
drop_ddl_stmt:
drop_database_stmt drop_index_stmt drop_table_stmt drop_view_stmt drop_sequence_stmt
drop_role_stmt:
DROP ROLE IF EXISTS string_or_placeholder_list
drop_user_stmt:
DROP USER IF EXISTS string_or_placeholder_list
explain_option_list:
explain_option_name ,
string_or_placeholder_list:
string_or_placeholder ,
table_elem_list:
table_elem ,
insert_target:
table_name AS table_alias_name
insert_rest:
( insert_column_list ) select_stmt DEFAULT VALUES
on_conflict:
ON CONFLICT opt_conf_expr DO UPDATE SET set_clause_list opt_where_clause NOTHING
a_expr:
c_expr + - ~ NOT a_expr DEFAULT TYPECAST cast_target TYPEANNOTATE typename COLLATE collation_name + 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 INET_CONTAINS_OR_CONTAINED_BY a_expr INET_CONTAINS_OR_EQUALS a_expr LESS_EQUALS a_expr GREATER_EQUALS a_expr NOT_EQUALS 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
reset_session_stmt:
RESET SESSION session_var
reset_csetting_stmt:
RESET CLUSTER SETTING var_name
as_of_clause:
AS OF SYSTEM TIME a_expr
scrub_table_stmt:
EXPERIMENTAL SCRUB TABLE table_name opt_as_of_clause opt_scrub_options_clause
scrub_database_stmt:
EXPERIMENTAL SCRUB DATABASE database_name opt_as_of_clause
select_no_parens:
simple_select select_clause sort_clause opt_sort_clause select_limit with_clause select_clause sort_clause opt_sort_clause select_limit
select_with_parens:
( select_no_parens select_with_parens )
set_session_stmt:
SET SESSION set_rest_more CHARACTERISTICS AS TRANSACTION transaction_mode_list set_rest_more
set_csetting_stmt:
SET CLUSTER SETTING var_name to_or_eq var_value
use_stmt:
USE var_value
show_backup_stmt:
SHOW BACKUP string_or_placeholder
show_columns_stmt:
SHOW COLUMNS FROM table_name
show_constraints_stmt:
SHOW CONSTRAINT CONSTRAINTS FROM table_name
show_create_stmt:
SHOW CREATE table_name
show_csettings_stmt:
SHOW CLUSTER SETTING var_name ALL ALL CLUSTER SETTINGS
show_databases_stmt:
SHOW DATABASES
show_grants_stmt:
SHOW GRANTS opt_on_targets_roles for_grantee_clause
show_indexes_stmt:
SHOW INDEX INDEXES KEYS FROM table_name
show_jobs_stmt:
SHOW opt_automatic JOBS
show_queries_stmt:
SHOW ALL opt_cluster QUERIES
show_ranges_stmt:
SHOW ranges_kw FROM TABLE table_name INDEX table_index_name
show_roles_stmt:
SHOW ROLES
show_schemas_stmt:
SHOW SCHEMAS FROM name
show_sequences_stmt:
SHOW SEQUENCES FROM name
show_session_stmt:
SHOW SESSION session_var
show_sessions_stmt:
SHOW ALL opt_cluster SESSIONS
show_stats_stmt:
SHOW STATISTICS FOR TABLE table_name
show_tables_stmt:
SHOW TABLES FROM name . name with_comment
show_trace_stmt:
SHOW opt_compact KV TRACE FOR SESSION
show_users_stmt:
SHOW USERS
show_zone_stmt:
SHOW ZONE CONFIGURATION FOR RANGE zone_name DATABASE database_name TABLE table_name opt_partition PARTITION partition_name OF TABLE table_name INDEX table_index_name CONFIGURATIONS ALL ZONE CONFIGURATIONS
opt_table:
TABLE
relation_expr_list:
relation_expr ,
opt_drop_behavior:
CASCADE RESTRICT
set_clause_list:
set_clause ,
db_object_name:
simple_db_object_name complex_db_object_name
prefixed_column_path:
db_object_name_component . unrestricted_name . unrestricted_name . unrestricted_name
expr_list:
a_expr ,
unreserved_keyword:
ABORT ACTION ADD ADMIN AGGREGATE ALTER AT AUTOMATIC BACKUP BEGIN BIGSERIAL BLOB BOOL BY BYTEA BYTES CACHE CANCEL CASCADE CHANGEFEED CLUSTER COLUMNS COMMENT COMMIT COMMITTED COMPACT CONFLICT CONFIGURATION CONFIGURATIONS CONFIGURE CONSTRAINTS CONVERSION COPY COVERING CUBE CURRENT CYCLE DATA DATABASE DATABASES DATE DAY DEALLOCATE DELETE DEFERRED DISCARD DOMAIN DOUBLE DROP ENCODING ENUM ESCAPE EXECUTE EXPERIMENTAL EXPERIMENTAL_AUDIT EXPERIMENTAL_FINGERPRINTS EXPERIMENTAL_RANGES EXPERIMENTAL_RELOCATE EXPERIMENTAL_REPLICA EXPLAIN EXPORT EXTENSION FILES FILTER FIRST FLOAT4 FLOAT8 FOLLOWING FORCE_INDEX FUNCTION GLOBAL GRANTS GROUPS HASH HIGH HISTOGRAM HOUR IMMEDIATE IMPORT INCREMENT INCREMENTAL INDEXES INET INJECT INSERT INT2 INT2VECTOR INT4 INT8 INT64 INTERLEAVE INVERTED ISOLATION JOB JOBS JSON JSONB KEY KEYS KV LANGUAGE LC_COLLATE LC_CTYPE LEASE LESS LEVEL LIST LOCAL LOOKUP LOW MATCH MATERIALIZED MAXVALUE MERGE MINUTE MINVALUE MONTH NAMES NAN NAME NEXT NO NORMAL NO_INDEX_JOIN OF OFF OID OIDS OIDVECTOR OPERATOR OPT OPTION OPTIONS ORDINALITY OVER OWNED PARENT PARTIAL PARTITION PASSWORD PAUSE PHYSICAL PLAN PLANS PRECEDING PREPARE PRIORITY PUBLICATION QUERIES QUERY RANGE RANGES READ RECURSIVE REF REGCLASS REGPROC REGPROCEDURE REGNAMESPACE REGTYPE RELEASE RENAME REPEATABLE REPLACE RESET RESTORE RESTRICT RESUME REVOKE ROLE ROLES ROLLBACK ROLLUP ROWS RULE SETTING SETTINGS STATUS SAVEPOINT SCATTER SCHEMA SCHEMAS SCRUB SEARCH SECOND SERIAL SERIALIZABLE SERIAL2 SERIAL4 SERIAL8 SERVER SEQUENCE SEQUENCES SESSION SESSIONS SET SHOW SIMPLE SMALLSERIAL SNAPSHOT SQL START STATISTICS STDIN STORE STORED STORING STRICT STRING SPLIT SUBSCRIPTION SYNTAX SYSTEM TABLES TEMP TEMPLATE TEMPORARY TESTING_RANGES TESTING_RELOCATE TEXT TRACE TRANSACTION TRIGGER TRUNCATE TRUSTED TYPE THROTTLING UNBOUNDED UNCOMMITTED UNKNOWN UNLOGGED UPDATE UPSERT UUID USE USERS VALID VALIDATE VALUE VARYING VIEW WITHIN WITHOUT WRITE YEAR ZONE
col_name_keyword:
ANNOTATE_TYPE BETWEEN BIGINT BIT BOOLEAN CHAR CHARACTER CHARACTERISTICS COALESCE DEC DECIMAL EXISTS EXTRACT EXTRACT_DURATION FLOAT GREATEST GROUPING IF IFERROR IFNULL INT INTEGER INTERVAL ISERROR LEAST NULLIF NUMERIC OUT OVERLAY POSITION PRECISION REAL ROW SMALLINT SUBSTRING TIME TIMETZ TIMESTAMP TIMESTAMPTZ TREAT TRIM VALUES VARBIT VARCHAR VIRTUAL WORK
non_reserved_word_or_sconst:
non_reserved_word SCONST
kv_option_list:
kv_option ,
complex_table_pattern:
complex_db_object_name db_object_name_component . unrestricted_name . *
table_pattern:
simple_db_object_name complex_table_pattern
table_pattern_list:
table_pattern ,
privilege:
name CREATE GRANT SELECT
type_list:
typename ,
transaction_mode_list:
transaction_mode opt_comma
opt_transaction:
TRANSACTION
begin_transaction:
transaction_mode_list
opt_to_savepoint:
TRANSACTION TO savepoint_name
opt_abort_mod:
TRANSACTION WORK
alter_table_stmt:
alter_onetable_stmt alter_split_stmt alter_scatter_stmt alter_zone_table_stmt alter_rename_table_stmt
alter_index_stmt:
alter_oneindex_stmt alter_split_index_stmt alter_scatter_index_stmt alter_rename_index_stmt alter_zone_index_stmt
alter_view_stmt:
alter_rename_view_stmt
alter_sequence_stmt:
alter_rename_sequence_stmt alter_sequence_options_stmt
alter_database_stmt:
alter_rename_database_stmt alter_zone_database_stmt
alter_range_stmt:
alter_zone_range_stmt
alter_user_password_stmt:
ALTER USER IF EXISTS string_or_placeholder WITH PASSWORD string_or_placeholder
opt_password:
opt_with PASSWORD string_or_placeholder
create_changefeed_stmt:
CREATE CHANGEFEED FOR changefeed_targets opt_changefeed_sink opt_with_options
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
create_index_stmt:
CREATE opt_unique INDEX opt_index_name IF NOT EXISTS index_name ON table_name opt_using_gin_btree INVERTED INDEX opt_index_name IF NOT EXISTS index_name ON table_name ( index_params ) opt_storing opt_interleave opt_partition_by
create_table_stmt:
CREATE TABLE IF NOT EXISTS table_name ( opt_table_elem_list ) opt_interleave opt_partition_by
create_table_as_stmt:
CREATE TABLE IF NOT EXISTS table_name opt_column_list AS select_stmt
create_view_stmt:
CREATE VIEW view_name opt_column_list AS select_stmt
create_sequence_stmt:
CREATE SEQUENCE IF NOT EXISTS sequence_name opt_sequence_option_list
statistics_name:
name
opt_stats_columns:
ON name_list
create_stats_target:
table_name
opt_create_stats_options:
as_of_clause
with_clause:
WITH cte_list
table_name_expr_with_index:
table_name opt_index_flags
where_clause:
WHERE a_expr
sort_clause:
ORDER BY sortby_list
limit_clause:
LIMIT select_limit_value FETCH first_or_next opt_select_fetch_first_value row_or_rows ONLY
target_list:
target_elem ,
drop_database_stmt:
DROP DATABASE IF EXISTS database_name opt_drop_behavior
drop_index_stmt:
DROP INDEX IF EXISTS table_index_name_list opt_drop_behavior
drop_table_stmt:
DROP TABLE IF EXISTS table_name_list opt_drop_behavior
drop_view_stmt:
DROP VIEW IF EXISTS table_name_list opt_drop_behavior
drop_sequence_stmt:
DROP SEQUENCE IF EXISTS table_name_list opt_drop_behavior
explain_option_name:
non_reserved_word
table_elem:
column_def index_def family_def table_constraint
insert_column_list:
insert_column_item ,
opt_conf_expr:
( name_list )
c_expr:
d_expr array_subscripts case_expr EXISTS select_with_parens
cast_target:
typename
typename:
simple_typename opt_array_bounds ARRAY postgres_oid
collation_name:
unrestricted_name
opt_asymmetric:
ASYMMETRIC
b_expr:
c_expr + - ~ b_expr TYPECAST cast_target TYPEANNOTATE typename + - * / FLOORDIV % ^ # & | < > = CONCAT LSHIFT RSHIFT LESS_EQUALS GREATER_EQUALS NOT_EQUALS b_expr IS NOT DISTINCT FROM b_expr OF ( type_list )
in_expr:
select_with_parens expr_tuple1_ambiguous
subquery_op:
math_op NOT LIKE ILIKE
sub_type:
ANY SOME ALL
session_var:
identifier ALL DATABASE NAMES SESSION_USER TIME ZONE
var_name:
name attrs
opt_scrub_options_clause:
WITH OPTIONS scrub_option_list
simple_select:
simple_select_clause values_clause table_clause set_operation
select_clause:
simple_select select_with_parens
select_limit:
limit_clause offset_clause offset_clause limit_clause
set_rest_more:
generic_set
to_or_eq:
= TO
var_value:
a_expr extra_var_value
opt_on_targets_roles:
ON targets_roles
for_grantee_clause:
FOR name_list
opt_automatic:
AUTOMATIC
opt_cluster:
CLUSTER LOCAL
ranges_kw:
TESTING_RANGES EXPERIMENTAL_RANGES
table_index_name:
table_name @ index_name standalone_index_name
with_comment:
WITH COMMENT
opt_compact:
COMPACT
zone_name:
unrestricted_name
opt_partition:
partition
partition_name:
unrestricted_name
relation_expr:
table_name * ONLY table_name ( table_name )
set_clause:
single_set_clause multiple_set_clause
simple_db_object_name:
db_object_name_component
complex_db_object_name:
db_object_name_component . unrestricted_name . unrestricted_name
db_object_name_component:
name FAMILY cockroachdb_extra_reserved_keyword
unrestricted_name:
identifier unreserved_keyword col_name_keyword type_func_name_keyword reserved_keyword
non_reserved_word:
identifier unreserved_keyword col_name_keyword type_func_name_keyword
kv_option:
name SCONST = string_or_placeholder
transaction_mode:
transaction_user_priority transaction_read_mode as_of_clause
opt_comma:
,
alter_onetable_stmt:
ALTER TABLE IF EXISTS relation_expr alter_table_cmds
alter_split_stmt:
ALTER TABLE table_name SPLIT AT select_stmt
alter_scatter_stmt:
ALTER TABLE table_name SCATTER FROM ( expr_list ) TO ( expr_list )
alter_zone_table_stmt:
ALTER PARTITION partition_name OF TABLE table_name set_zone_config
alter_rename_table_stmt:
ALTER TABLE IF EXISTS relation_expr RENAME TO table_name
alter_oneindex_stmt:
ALTER INDEX IF EXISTS table_index_name alter_index_cmds
alter_split_index_stmt:
ALTER INDEX table_index_name SPLIT AT select_stmt
alter_scatter_index_stmt:
ALTER INDEX table_index_name SCATTER FROM ( expr_list ) TO ( expr_list )
alter_rename_index_stmt:
ALTER INDEX IF EXISTS table_index_name RENAME TO index_name
alter_zone_index_stmt:
ALTER INDEX table_index_name set_zone_config
alter_rename_view_stmt:
ALTER VIEW IF EXISTS relation_expr RENAME TO view_name
alter_rename_sequence_stmt:
ALTER SEQUENCE IF EXISTS relation_expr RENAME TO sequence_name
alter_sequence_options_stmt:
ALTER SEQUENCE IF EXISTS sequence_name sequence_option_list
alter_rename_database_stmt:
ALTER DATABASE database_name RENAME TO database_name
alter_zone_database_stmt:
ALTER DATABASE database_name set_zone_config
alter_zone_range_stmt:
ALTER RANGE zone_name set_zone_config
opt_with:
WITH
changefeed_targets:
TABLE single_table_pattern_list
opt_changefeed_sink:
INTO string_or_placeholder
opt_template_clause:
TEMPLATE opt_equal non_reserved_word_or_sconst
opt_encoding_clause:
ENCODING opt_equal non_reserved_word_or_sconst
opt_lc_collate_clause:
LC_COLLATE opt_equal non_reserved_word_or_sconst
opt_lc_ctype_clause:
LC_CTYPE opt_equal non_reserved_word_or_sconst
opt_unique:
UNIQUE
opt_index_name:
opt_name
opt_using_gin_btree:
USING name
index_params:
index_elem ,
opt_storing:
storing ( name_list )
opt_interleave:
INTERLEAVE IN PARENT table_name ( name_list )
opt_partition_by:
partition_by
index_name:
unrestricted_name
opt_table_elem_list:
table_elem_list
view_name:
table_name
sequence_name:
db_object_name
opt_sequence_option_list:
sequence_option_list
cte_list:
common_table_expr ,
opt_index_flags:
@ index_name [ ICONST ] { index_flags_param_list }
sortby_list:
sortby ,
select_limit_value:
a_expr ALL
first_or_next:
FIRST NEXT
opt_select_fetch_first_value:
signed_iconst ( a_expr )
row_or_rows:
ROW ROWS
target_elem:
a_expr AS target_name identifier *
table_index_name_list:
table_index_name ,
table_name_list:
table_name ,
column_def:
column_name typename col_qual_list
index_def:
UNIQUE INDEX opt_index_name ( index_params ) opt_storing opt_interleave opt_partition_by INVERTED INDEX opt_name ( index_params )
family_def:
FAMILY opt_family_name ( name_list )
table_constraint:
CONSTRAINT constraint_name constraint_elem
insert_column_item:
column_name
d_expr:
@ ICONST FCONST const_typename SCONST BCONST BITCONST interval TRUE FALSE NULL column_path_with_star PLACEHOLDER ( a_expr ) . * unrestricted_name func_expr select_with_parens labeled_row ARRAY select_with_parens row array_expr
array_subscripts:
array_subscript
case_expr:
CASE case_arg when_clause_list case_default END
simple_typename:
const_typename bit_with_length character_with_length INTERVAL
opt_array_bounds:
[ ]
postgres_oid:
REGPROC REGPROCEDURE REGCLASS REGTYPE REGNAMESPACE
expr_tuple1_ambiguous:
( tuple1_ambiguous_values )
math_op:
+ - * / FLOORDIV % & | ^ # < > = LESS_EQUALS GREATER_EQUALS NOT_EQUALS
attrs:
. unrestricted_name
scrub_option_list:
scrub_option ,
simple_select_clause:
SELECT opt_all_clause DISTINCT distinct_on_clause target_list from_clause opt_where_clause group_clause having_clause window_clause
values_clause:
VALUES ( expr_list ) ,
table_clause:
TABLE table_ref
set_operation:
select_clause UNION INTERSECT EXCEPT all_or_distinct select_clause
offset_clause:
OFFSET a_expr c_expr row_or_rows
generic_set:
var_name to_or_eq var_list
extra_var_value:
ON cockroachdb_extra_reserved_keyword
targets_roles:
ROLE name_list targets
standalone_index_name:
db_object_name
partition:
PARTITION partition_name
single_set_clause:
column_name = a_expr
multiple_set_clause:
( insert_column_list ) = in_expr
cockroachdb_extra_reserved_keyword:
INDEX NOTHING
type_func_name_keyword:
COLLATION CROSS FULL INNER ILIKE IS ISNULL JOIN LEFT LIKE NATURAL NOTNULL OUTER OVERLAPS RIGHT SIMILAR FAMILY
reserved_keyword:
ALL ANALYSE ANALYZE AND ANY ARRAY AS ASC ASYMMETRIC BOTH CASE CAST CHECK COLLATE COLUMN 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
transaction_user_priority:
PRIORITY user_priority
transaction_read_mode:
READ ONLY WRITE
alter_table_cmds:
alter_table_cmd ,
set_zone_config:
CONFIGURE ZONE USING var_set_list DISCARD
alter_index_cmds:
alter_index_cmd ,
sequence_option_list:
sequence_option_elem
single_table_pattern_list:
table_name ,
opt_equal:
=
opt_name:
name
index_elem:
a_expr opt_asc_desc
storing:
COVERING STORING
partition_by:
PARTITION BY LIST ( name_list ) ( list_partitions RANGE ( name_list ) ( range_partitions ) NOTHING
common_table_expr:
table_alias_name opt_column_list AS ( preparable_stmt )
index_flags_param_list:
index_flags_param ,
sortby:
a_expr PRIMARY KEY table_name INDEX table_name @ index_name opt_asc_desc
signed_iconst:
+ - ICONST
target_name:
unrestricted_name
column_name:
name
col_qual_list:
col_qualification
opt_family_name:
opt_name
constraint_name:
name
constraint_elem:
CHECK ( a_expr PRIMARY KEY ( index_params ) UNIQUE ( index_params ) opt_storing opt_interleave opt_partition_by FOREIGN KEY ( name_list ) REFERENCES table_name opt_column_list key_match reference_actions
const_typename:
numeric bit_without_length character_without_length const_datetime const_json BLOB BYTES BYTEA TEXT NAME SERIAL SERIAL2 SMALLSERIAL SERIAL4 SERIAL8 BIGSERIAL UUID INET OID OIDVECTOR INT2VECTOR identifier
interval:
INTERVAL SCONST opt_interval
column_path_with_star:
column_path db_object_name_component . unrestricted_name . unrestricted_name . *
func_expr:
func_application filter_clause over_clause func_expr_common_subexpr
labeled_row:
row ( row AS name_list )
row:
ROW ( opt_expr_list ) expr_tuple_unambiguous
array_expr:
[ opt_expr_list array_expr_list ]
array_subscript:
[ a_expr opt_slice_bound : opt_slice_bound ]
case_arg:
a_expr
when_clause_list:
when_clause
case_default:
ELSE a_expr
bit_with_length:
BIT opt_varying VARBIT ( ICONST )
character_with_length:
character_base ( ICONST )
tuple1_ambiguous_values:
a_expr , expr_list
scrub_option:
INDEX CONSTRAINT ALL ( name_list ) PHYSICAL
opt_all_clause:
ALL
from_clause:
FROM from_list opt_as_of_clause
group_clause:
GROUP BY expr_list
having_clause:
HAVING a_expr
window_clause:
WINDOW window_definition_list
distinct_on_clause:
DISTINCT ON ( expr_list )
table_ref:
relation_expr opt_index_flags select_with_parens func_table [ preparable_stmt ] opt_ordinality opt_alias_clause joined_table ( joined_table ) opt_ordinality alias_clause
all_or_distinct:
ALL DISTINCT
var_list:
var_value ,
user_priority:
LOW NORMAL HIGH
alter_table_cmd:
RENAME opt_column CONSTRAINT column_name TO column_name ADD COLUMN IF NOT EXISTS column_def table_constraint opt_validate_behavior ALTER opt_column column_name alter_column_default DROP NOT NULL STORED opt_set_data TYPE typename opt_collate opt_alter_column_using 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
var_set_list:
var_name = COPY FROM PARENT var_value , var_name = var_value COPY FROM PARENT
alter_index_cmd:
partition_by
sequence_option_elem:
NO CYCLE MINVALUE MAXVALUE INCREMENT BY MINVALUE MAXVALUE START WITH signed_iconst64 VIRTUAL
opt_asc_desc:
ASC DESC
list_partitions:
list_partition ,
range_partitions:
range_partition ,
index_flags_param:
FORCE_INDEX = index_name NO_INDEX_JOIN
col_qualification:
CONSTRAINT constraint_name col_qualification_elem COLLATE collation_name FAMILY family_name CREATE FAMILY family_name IF NOT EXISTS FAMILY family_name
key_match:
MATCH SIMPLE FULL
reference_actions:
reference_on_update reference_on_delete reference_on_delete reference_on_update
numeric:
INT INTEGER INT2 SMALLINT INT4 INT8 INT64 BIGINT REAL FLOAT4 FLOAT8 FLOAT opt_float DOUBLE PRECISION DECIMAL DEC NUMERIC opt_numeric_modifiers BOOLEAN BOOL
bit_without_length:
BIT VARYING VARBIT
character_without_length:
character_base
const_datetime:
DATE TIMESTAMP opt_timezone TIMESTAMPTZ
const_json:
JSON JSONB
opt_interval:
interval_qualifier
func_application:
func_name ( ALL DISTINCT expr_list * )
filter_clause:
FILTER ( WHERE a_expr )
over_clause:
OVER window_specification window_name
func_expr_common_subexpr:
CURRENT_DATE CURRENT_SCHEMA CURRENT_CATALOG CURRENT_TIMESTAMP CURRENT_USER CURRENT_ROLE SESSION_USER USER CAST ( a_expr AS cast_target ANNOTATE_TYPE ( a_expr , typename IF ( a_expr , NULLIF IFNULL ( IFERROR ( a_expr , a_expr , ISERROR ( a_expr , a_expr COALESCE ( expr_list ) special_function
opt_expr_list:
expr_list
expr_tuple_unambiguous:
( tuple1_unambiguous_values )
array_expr_list:
array_expr ,
opt_slice_bound:
a_expr
when_clause:
WHEN a_expr THEN a_expr
opt_varying:
VARYING
character_base:
char_aliases VARYING VARCHAR STRING
from_list:
table_ref ,
window_definition_list:
window_definition ,
opt_ordinality:
WITH ORDINALITY
opt_alias_clause:
alias_clause
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
alias_clause:
AS table_alias_name opt_column_list
func_table:
func_expr_windowless ROWS FROM ( rowsfrom_list )
opt_column:
COLUMN
alter_column_default:
SET DEFAULT a_expr DROP DEFAULT
opt_set_data:
SET DATA
opt_collate:
COLLATE collation_name
opt_alter_column_using:
USING a_expr
opt_validate_behavior:
NOT VALID
audit_mode:
READ WRITE OFF
signed_iconst64:
signed_iconst
list_partition:
partition VALUES IN ( expr_list ) opt_partition_by
range_partition:
partition VALUES FROM ( expr_list ) TO ( expr_list ) opt_partition_by
col_qualification_elem:
NOT NULL UNIQUE PRIMARY KEY CHECK ( a_expr ) DEFAULT b_expr REFERENCES table_name opt_name_parens key_match reference_actions AS ( a_expr ) STORED
family_name:
name
reference_on_update:
ON UPDATE reference_action
reference_on_delete:
ON DELETE reference_action
opt_float:
( ICONST )
opt_numeric_modifiers:
( ICONST , ICONST )
opt_timezone:
WITH WITHOUT TIME ZONE
interval_qualifier:
YEAR TO MONTH MONTH DAY TO HOUR MINUTE SECOND HOUR TO MINUTE SECOND MINUTE TO SECOND SECOND
func_name:
type_function_name prefixed_column_path
window_specification:
( opt_existing_window_name opt_partition_clause opt_sort_clause opt_frame_clause )
window_name:
name
special_function:
CURRENT_DATE CURRENT_SCHEMA CURRENT_TIMESTAMP CURRENT_USER ( EXTRACT EXTRACT_DURATION ( extract_list OVERLAY ( overlay_list POSITION ( position_list SUBSTRING ( substr_list GREATEST LEAST ( expr_list TRIM ( BOTH LEADING TRAILING trim_list )
tuple1_unambiguous_values:
a_expr , expr_list
char_aliases:
CHAR CHARACTER
window_definition:
window_name AS window_specification
opt_join_hint:
HASH MERGE LOOKUP
join_type:
FULL LEFT RIGHT join_outer INNER
join_qual:
USING ( name_list ) ON a_expr
func_expr_windowless:
func_application func_expr_common_subexpr
rowsfrom_list:
rowsfrom_item ,
opt_name_parens:
( name )
reference_action:
NO ACTION RESTRICT CASCADE SET NULL DEFAULT
type_function_name:
identifier unreserved_keyword type_func_name_keyword
opt_existing_window_name:
name
opt_partition_clause:
PARTITION BY expr_list
opt_frame_clause:
RANGE ROWS GROUPS frame_extent
extract_list:
extract_arg FROM a_expr expr_list
overlay_list:
a_expr overlay_placing substr_from substr_for expr_list
position_list:
b_expr IN b_expr
substr_list:
a_expr substr_from substr_for substr_for substr_from opt_expr_list
trim_list:
a_expr FROM expr_list
join_outer:
OUTER
rowsfrom_item:
func_expr_windowless
frame_extent:
BETWEEN frame_bound AND frame_bound
extract_arg:
identifier YEAR MONTH DAY HOUR MINUTE SECOND
overlay_placing:
PLACING a_expr
substr_from:
FROM a_expr
substr_for:
FOR a_expr
frame_bound:
UNBOUNDED a_expr PRECEDING FOLLOWING CURRENT ROW
generated by Railroad Diagram Generator
Was this page helpful?Yes No
我的书签
添加书签
移除书签
