stmt_block:
stmt
no references
stmt:
HELPTOKEN
preparable_stmt
analyze_stmt
copy_from_stmt
comment_stmt
execute_stmt
deallocate_stmt
discard_stmt
grant_stmt
prepare_stmt
revoke_stmt
savepoint_stmt
reassign_owned_stmt
release_stmt
refresh_stmt
nonpreparable_set_stmt
transaction_stmt
close_cursor_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:
copy_from_stmt:
COPY
table_name
opt_column_list
FROM
STDIN
opt_with_copy_options
opt_where_clause
referenced by:
comment_stmt:
COMMENT
ON
DATABASE
database_name
TABLE
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
referenced by:
grant_stmt:
GRANT
privileges
ON
targets
TYPE
target_types
SCHEMA
name_list
TO
name_list
privilege_list
TO
name_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
targets
TYPE
target_types
SCHEMA
name_list
ADMIN
OPTION
FOR
privilege_list
FROM
name_list
referenced by:
savepoint_stmt:
SAVEPOINT
name
referenced by:
reassign_owned_stmt:
REASSIGN
OWNED
BY
role_spec_list
TO
role_spec
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
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
TO
string_or_placeholder_opt_list
opt_as_of_clause
opt_incremental
opt_with_backup_options
referenced by:
cancel_stmt:
cancel_jobs_stmt
cancel_queries_stmt
cancel_sessions_stmt
referenced by:
create_stmt:
create_role_stmt
create_ddl_stmt
create_stats_stmt
create_schedule_for_backup_stmt
create_extension_stmt
referenced by:
delete_stmt:
opt_with_clause
DELETE
FROM
table_expr_opt_alias_idx
opt_where_clause
opt_sort_clause
opt_limit_clause
returning_clause
referenced by:
drop_stmt:
drop_ddl_stmt
drop_role_stmt
drop_schedule_stmt
referenced by:
explain_stmt:
EXPLAIN
ANALYZE
ANALYSE
(
explain_option_list
)
preparable_stmt
referenced by:
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
)
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
referenced by:
reset_stmt:
reset_session_stmt
reset_csetting_stmt
referenced by:
restore_stmt:
RESTORE
FROM
targets
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
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_csetting_stmt
use_stmt
referenced by:
show_stmt:
show_backup_stmt
show_columns_stmt
show_constraints_stmt
show_create_stmt
show_csettings_stmt
show_databases_stmt
show_enums_stmt
show_types_stmt
show_grants_stmt
show_indexes_stmt
show_partitions_stmt
show_jobs_stmt
show_schedules_stmt
show_queries_stmt
show_ranges_stmt
show_range_for_row_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_users_stmt
show_zone_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:
table_name:
db_object_name
referenced by:
opt_column_list:
(
name_list
)
referenced by:
opt_with_copy_options:
opt_with
copy_options_list
referenced by:
opt_where_clause:
where_clause
referenced by:
database_name:
name
referenced by:
comment_text:
SCONST
NULL
referenced by:
column_path:
name
prefixed_column_path
referenced by:
table_index_name:
table_name
@
index_name
standalone_index_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:
targets:
identifier
col_name_keyword
unreserved_keyword
complex_table_pattern
table_pattern
,
TABLE
table_pattern_list
TENANT
ICONST
DATABASE
name_list
referenced by:
name_list:
name
,
referenced by:
privilege_list:
privilege
,
referenced by:
target_types:
type_name_list
referenced by:
prep_type_clause:
(
type_list
)
referenced by:
role_spec_list:
role_spec
,
referenced by:
role_spec:
non_reserved_word_or_sconst
CURRENT_USER
SESSION_USER
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:
BEGIN
opt_transaction
START
TRANSACTION
begin_transaction
referenced by:
commit_stmt:
COMMIT
END
opt_transaction
referenced by:
rollback_stmt:
ROLLBACK
opt_transaction
TO
savepoint_name
referenced by:
abort_stmt:
ABORT
opt_abort_mod
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
referenced by:
alter_role_stmt:
ALTER
role_or_group_or_user
IF
EXISTS
string_or_placeholder
opt_role_options
referenced by:
opt_backup_targets:
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:
opt_incremental:
INCREMENTAL
FROM
string_or_placeholder_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:
create_role_stmt:
CREATE
role_or_group_or_user
IF
NOT
EXISTS
string_or_placeholder
opt_role_options
referenced by:
create_ddl_stmt:
create_changefeed_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
referenced by:
create_stats_stmt:
CREATE
STATISTICS
statistics_name
opt_stats_columns
FROM
create_stats_target
opt_create_stats_options
referenced by:
create_schedule_for_backup_stmt:
CREATE
SCHEDULE
opt_description
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:
create_extension_stmt:
CREATE
EXTENSION
IF
NOT
EXISTS
name
referenced by:
opt_with_clause:
with_clause
referenced by:
table_expr_opt_alias_idx:
table_name_opt_idx
AS
table_alias_name
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
referenced by:
drop_role_stmt:
DROP
role_or_group_or_user
IF
EXISTS
string_or_placeholder_list
referenced by:
drop_schedule_stmt:
DROP
SCHEDULE
a_expr
SCHEDULES
select_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:
string_or_placeholder_list:
string_or_placeholder
,
referenced by:
table_elem_list:
table_elem
,
referenced by:
insert_column_list:
insert_column_item
,
referenced by:
insert_target:
table_name
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
DO
NOTHING
UPDATE
SET
set_clause_list
opt_where_clause
referenced by:
pause_jobs_stmt:
PAUSE
JOB
a_expr
JOBS
select_stmt
for_schedules_clause
referenced by:
pause_schedules_stmt:
PAUSE
SCHEDULE
a_expr
SCHEDULES
select_stmt
referenced by:
reset_session_stmt:
RESET
SESSION
session_var
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:
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:
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_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
BACKUP
string_or_placeholder
IN
SCHEMAS
string_or_placeholder
opt_with_options
referenced by:
show_columns_stmt:
SHOW
COLUMNS
FROM
table_name
with_comment
referenced by:
show_constraints_stmt:
SHOW
CONSTRAINT
CONSTRAINTS
FROM
table_name
referenced by:
show_create_stmt:
SHOW
CREATE
table_name
referenced by:
show_csettings_stmt:
SHOW
CLUSTER
SETTING
var_name
ALL
SETTINGS
ALL
PUBLIC
CLUSTER
SETTINGS
referenced by:
show_databases_stmt:
SHOW
DATABASES
with_comment
referenced by:
show_enums_stmt:
SHOW
ENUMS
referenced by:
show_types_stmt:
SHOW
TYPES
referenced by:
show_grants_stmt:
SHOW
GRANTS
opt_on_targets_roles
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
WHEN
COMPLETE
select_stmt
for_schedules_clause
JOB
WHEN
COMPLETE
a_expr
referenced by:
show_schedules_stmt:
SHOW
schedule_state
SCHEDULES
opt_schedule_executor_type
SCHEDULE
a_expr
referenced by:
show_queries_stmt:
SHOW
ALL
opt_cluster
QUERIES
referenced by:
show_ranges_stmt:
SHOW
RANGES
FROM
TABLE
table_name
INDEX
table_index_name
DATABASE
database_name
referenced by:
show_range_for_row_stmt:
SHOW
RANGE
FROM
TABLE
table_name
INDEX
table_index_name
FOR
ROW
(
expr_list
)
referenced by:
show_roles_stmt:
SHOW
ROLES
referenced by:
show_savepoint_stmt:
SHOW
SAVEPOINT
STATUS
referenced by:
show_schemas_stmt:
SHOW
SCHEMAS
FROM
name
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
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_users_stmt:
SHOW
USERS
referenced by:
show_zone_stmt:
SHOW
ZONE
CONFIGURATION
FOR
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:
opt_table:
TABLE
referenced by:
relation_expr_list:
relation_expr
,
referenced by:
opt_drop_behavior:
CASCADE
RESTRICT
referenced by:
set_clause_list:
set_clause
,
referenced by:
opt_from_list:
FROM
from_list
referenced by:
db_object_name:
simple_db_object_name
complex_db_object_name
referenced by:
opt_with:
WITH
referenced by:
copy_options_list:
copy_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:
expr_list:
a_expr
,
referenced by:
unreserved_keyword:
ABORT
ACTION
ACCESS
ADD
ADMIN
AFTER
AGGREGATE
ALTER
ALWAYS
AT
ATTRIBUTE
AUTOMATIC
BACKUP
BACKUPS
BEFORE
BEGIN
BINARY
BUCKET_COUNT
BUNDLE
BY
CACHE
CANCEL
CANCELQUERY
CASCADE
CHANGEFEED
CLOSE
CLUSTER
COLUMNS
COMMENT
COMMENTS
COMMIT
COMMITTED
COMPACT
COMPLETE
CONFLICT
CONFIGURATION
CONFIGURATIONS
CONFIGURE
CONNECTION
CONSTRAINTS
CONTROLCHANGEFEED
CONTROLJOB
CONVERSION
CONVERT
COPY
COVERING
CREATEDB
CREATELOGIN
CREATEROLE
CUBE
CURRENT
CYCLE
DATA
DATABASE
DATABASES
DAY
DEALLOCATE
DECLARE
DELETE
DEFAULTS
DEFERRED
DESTINATION
DETACHED
DISCARD
DOMAIN
DOUBLE
DROP
ENCODING
ENCRYPTION_PASSPHRASE
ENUM
ENUMS
ESCAPE
EXCLUDE
EXCLUDING
EXECUTE
EXECUTION
EXPERIMENTAL
EXPERIMENTAL_AUDIT
EXPERIMENTAL_FINGERPRINTS
EXPERIMENTAL_RELOCATE
EXPERIMENTAL_REPLICA
EXPIRATION
EXPLAIN
EXPORT
EXTENSION
FILES
FILTER
FIRST
FOLLOWING
FORCE_INDEX
FUNCTION
GENERATED
GEOMETRYM
GEOMETRYZ
GEOMETRYZM
GEOMETRYCOLLECTION
GEOMETRYCOLLECTIONM
GEOMETRYCOLLECTIONZ
GEOMETRYCOLLECTIONZM
GLOBAL
GRANTS
GROUPS
HASH
HIGH
HISTOGRAM
HOUR
IDENTITY
IMMEDIATE
IMPORT
INCLUDE
INCLUDING
INCREMENT
INCREMENTAL
INDEXES
INHERITS
INJECT
INSERT
INTERLEAVE
INTO_DB
INVERTED
ISOLATION
JOB
JOBS
JSON
KEY
KEYS
KMS
KV
LANGUAGE
LAST
LATEST
LC_COLLATE
LC_CTYPE
LEASE
LESS
LEVEL
LINESTRING
LIST
LOCAL
LOCKED
LOGIN
LOOKUP
LOW
MATCH
MATERIALIZED
MAXVALUE
MERGE
METHOD
MINUTE
MINVALUE
MODIFYCLUSTERSETTING
MULTILINESTRING
MULTILINESTRINGM
MULTILINESTRINGZ
MULTILINESTRINGZM
MULTIPOINT
MULTIPOINTM
MULTIPOINTZ
MULTIPOINTZM
MULTIPOLYGON
MULTIPOLYGONM
MULTIPOLYGONZ
MULTIPOLYGONZM
MONTH
NAMES
NAN
NEVER
NEXT
NO
NORMAL
NO_INDEX_JOIN
NOCREATEDB
NOCREATELOGIN
NOCANCELQUERY
NOCREATEROLE
NOCONTROLCHANGEFEED
NOCONTROLJOB
NOLOGIN
NOMODIFYCLUSTERSETTING
NOVIEWACTIVITY
NOWAIT
NULLS
IGNORE_FOREIGN_KEYS
OF
OFF
OIDS
OPERATOR
OPT
OPTION
OPTIONS
ORDINALITY
OTHERS
OVER
OWNED
OWNER
PARENT
PARTIAL
PARTITION
PARTITIONS
PASSWORD
PAUSE
PAUSED
PHYSICAL
PLAN
PLANS
POINTM
POINTZ
POINTZM
POLYGONM
POLYGONZ
POLYGONZM
PRECEDING
PREPARE
PRESERVE
PRIORITY
PRIVILEGES
PUBLIC
PUBLICATION
QUERIES
QUERY
RANGE
RANGES
READ
REASSIGN
RECURRING
RECURSIVE
REF
REFRESH
REINDEX
RELEASE
RENAME
REPEATABLE
REPLACE
RESET
RESTORE
RESTRICT
RESUME
RETRY
REVISION_HISTORY
REVOKE
ROLE
ROLES
ROLLBACK
ROLLUP
ROWS
RULE
RUNNING
SCHEDULE
SCHEDULES
SETTING
SETTINGS
STATUS
SAVEPOINT
SCATTER
SCHEMA
SCHEMAS
SCRUB
SEARCH
SECOND
SERIALIZABLE
SEQUENCE
SEQUENCES
SERVER
SESSION
SESSIONS
SET
SETS
SHARE
SHOW
SIMPLE
SKIP
SKIP_MISSING_FOREIGN_KEYS
SKIP_MISSING_SEQUENCES
SKIP_MISSING_SEQUENCE_OWNERS
SKIP_MISSING_VIEWS
SNAPSHOT
SPLIT
SQL
START
STATISTICS
STDIN
STORAGE
STORE
STORED
STORING
STRICT
SUBSCRIPTION
SYNTAX
SYSTEM
TABLES
TABLESPACE
TEMP
TEMPLATE
TEMPORARY
TENANT
TESTING_RELOCATE
TEXT
TIES
TRACE
TRANSACTION
TRANSACTIONS
TRIGGER
TRUNCATE
TRUSTED
TYPE
TYPES
THROTTLING
UNBOUNDED
UNCOMMITTED
UNKNOWN
UNLOGGED
UNSPLIT
UNTIL
UPDATE
UPSERT
USE
USERS
VALID
VALIDATE
VALUE
VARYING
VIEW
VIEWACTIVITY
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
INT
INTEGER
INTERVAL
ISERROR
LEAST
NULLIF
NUMERIC
OUT
OVERLAY
POINT
POLYGON
POSITION
PRECISION
REAL
ROW
SMALLINT
STRING
SUBSTRING
TIME
TIMETZ
TIMESTAMP
TIMESTAMPTZ
TREAT
TRIM
VALUES
VARBIT
VARCHAR
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:
simple_db_object_name
complex_table_pattern
referenced by:
table_pattern_list:
table_pattern
,
referenced by:
privilege:
name
CREATE
GRANT
SELECT
referenced by:
type_name_list:
type_name
,
referenced by:
type_list:
typename
,
referenced by:
non_reserved_word_or_sconst:
non_reserved_word
SCONST
referenced by:
transaction_mode_list:
transaction_mode
opt_comma
referenced by:
opt_transaction:
TRANSACTION
referenced by:
begin_transaction:
transaction_mode_list
referenced by:
opt_abort_mod:
TRANSACTION
WORK
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
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
referenced by:
alter_view_stmt:
alter_rename_view_stmt
alter_view_set_schema_stmt
referenced by:
alter_sequence_stmt:
alter_rename_sequence_stmt
alter_sequence_options_stmt
alter_sequence_set_schema_stmt
referenced by:
alter_database_stmt:
alter_rename_database_stmt
alter_zone_database_stmt
alter_database_owner
alter_database_to_schema_stmt
referenced by:
alter_range_stmt:
alter_zone_range_stmt
referenced by:
alter_partition_stmt:
alter_zone_partition_stmt
referenced by:
alter_schema_stmt:
ALTER
SCHEMA
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
RENAME
VALUE
SCONST
TO
SCONST
TO
name
SET
SCHEMA
schema_name
OWNER
TO
role_spec
referenced by:
role_or_group_or_user:
ROLE
USER
referenced by:
opt_role_options:
opt_with
role_options
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
NOT
a_expr
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
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
referenced by:
for_schedules_clause:
FOR
SCHEDULES
select_stmt
SCHEDULE
a_expr
referenced by:
create_changefeed_stmt:
CREATE
CHANGEFEED
FOR
changefeed_targets
opt_changefeed_sink
opt_with_options
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
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_interleave
opt_partition_by
opt_with_storage_parameter_list
opt_where_clause
referenced by:
create_schema_stmt:
CREATE
SCHEMA
IF
NOT
EXISTS
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_interleave
opt_partition_by
opt_table_with
opt_create_table_on_commit
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
type_name
AS
ENUM
(
opt_enum_val_list
)
referenced by:
create_view_stmt:
CREATE
opt_temp
MATERIALIZED
VIEW
IF
NOT
EXISTS
OR
REPLACE
opt_temp
VIEW
view_name
opt_column_list
AS
select_stmt
referenced by:
create_sequence_stmt:
CREATE
opt_temp
SEQUENCE
IF
NOT
EXISTS
sequence_name
opt_sequence_option_list
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:
as_of_clause
referenced by:
opt_description:
string_or_placeholder
referenced by:
cron_expr:
RECURRING
sconst_or_placeholder
referenced by:
opt_full_backup_clause:
FULL
BACKUP
sconst_or_placeholder
ALWAYS
referenced by:
opt_with_schedule_options:
WITH
SCHEDULE
OPTIONS
kv_option_list
(
kv_option_list
)
referenced by:
with_clause:
WITH
RECURSIVE
cte_list
referenced by:
table_name_opt_idx:
opt_only
table_name
opt_index_flags
opt_descendant
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:
target_list:
target_elem
,
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
table_name_list
opt_drop_behavior
referenced by:
drop_sequence_stmt:
DROP
SEQUENCE
IF
EXISTS
table_name_list
opt_drop_behavior
referenced by:
drop_schema_stmt:
DROP
SCHEMA
IF
EXISTS
name_list
opt_drop_behavior
referenced by:
drop_type_stmt:
DROP
TYPE
IF
EXISTS
type_name_list
opt_drop_behavior
referenced by:
explain_option_name:
non_reserved_word
referenced by:
kv_option_list:
kv_option
,
referenced by:
table_elem:
column_def
index_def
family_def
table_constraint
LIKE
table_name
like_table_option_list
referenced by:
insert_column_item:
column_name
referenced by:
session_var:
identifier
ALL
DATABASE
NAMES
SESSION_USER
TIME
ZONE
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:
generic_set
referenced by:
to_or_eq:
=
TO
referenced by:
var_value:
a_expr
extra_var_value
referenced by:
with_comment:
WITH
COMMENT
referenced by:
opt_on_targets_roles:
ON
targets_roles
referenced by:
for_grantee_clause:
FOR
name_list
referenced by:
opt_schedule_executor_type:
FOR
BACKUP
referenced by:
schedule_state:
RUNNING
PAUSED
referenced by:
opt_cluster:
CLUSTER
LOCAL
referenced by:
opt_compact:
COMPACT
referenced by:
zone_name:
unrestricted_name
referenced by:
opt_partition:
partition
referenced by:
partition_name:
unrestricted_name
referenced by:
relation_expr:
table_name
*
ONLY
table_name
(
table_name
)
referenced by:
set_clause:
single_set_clause
multiple_set_clause
referenced by:
from_list:
table_ref
,
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
=
string_or_placeholder
BINARY
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:
type_name:
db_object_name
referenced by:
typename:
simple_typename
opt_array_bounds
ARRAY
referenced by:
non_reserved_word:
identifier
unreserved_keyword
col_name_keyword
type_func_name_keyword
referenced by:
transaction_mode:
transaction_user_priority
transaction_read_mode
as_of_clause
transaction_deferrable_mode
referenced by:
opt_comma:
,
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