> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Statements

CockroachDB supports the following SQL statements.

In the [`cockroach` SQL shell](https://docs.cockroachlabs.com/docs/v24.2/cockroach-sql#help), use `\h [statement]` to get inline help about a statement.

## Data definition statements

| Statement | Usage |
| - | - |
| [`ALTER DATABASE`](https://docs.cockroachlabs.com/docs/v24.2/alter-database) | Apply a schema change to a database. |
| [`ALTER DEFAULT PRIVILEGES`](https://docs.cockroachlabs.com/docs/v24.2/alter-default-privileges) | Change the default [privileges](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#privileges) for objects created by specific roles/users in the current database. |
| [`ALTER FUNCTION`](https://docs.cockroachlabs.com/docs/v24.2/alter-function) | Modify a [user-defined function](https://docs.cockroachlabs.com/docs/v24.2/user-defined-functions). |
| [`ALTER INDEX`](https://docs.cockroachlabs.com/docs/v24.2/alter-index) | Apply a schema change to an index. |
| [`ALTER PARTITION`](https://docs.cockroachlabs.com/docs/v24.2/alter-partition) | Configure the replication zone for a [partition](https://docs.cockroachlabs.com/docs/v24.2/partitioning). |
| [`ALTER PROCEDURE`](https://docs.cockroachlabs.com/docs/v24.2/alter-procedure) | Modify a [stored procedure](https://docs.cockroachlabs.com/docs/v24.2/stored-procedures). |
| [`ALTER RANGE`](https://docs.cockroachlabs.com/docs/v24.2/alter-range) | Configure the replication zone for a system range. |
| [`ALTER SCHEMA`](https://docs.cockroachlabs.com/docs/v24.2/alter-schema) | Alter a user-defined schema. |
| [`ALTER SEQUENCE`](https://docs.cockroachlabs.com/docs/v24.2/alter-sequence) | Apply a schema change to a sequence. |
| [`ALTER TABLE`](https://docs.cockroachlabs.com/docs/v24.2/alter-table) | Apply a schema change to a table. |
| [`ALTER TYPE`](https://docs.cockroachlabs.com/docs/v24.2/alter-type) | Modify a user-defined, [enumerated data type](https://docs.cockroachlabs.com/docs/v24.2/enum). |
| [`ALTER USER`](https://docs.cockroachlabs.com/docs/v24.2/alter-user) | Add, change, or remove a user's password and to change the login privileges for a role. |
| [`ALTER ROLE`](https://docs.cockroachlabs.com/docs/v24.2/alter-role) | Add, change, or remove a [role's](https://docs.cockroachlabs.com/docs/v24.2/create-role) password and to change the login privileges for a role. |
| [`ALTER VIEW`](https://docs.cockroachlabs.com/docs/v24.2/alter-view) | Apply a schema change to a view. |
| [`COMMENT ON`](https://docs.cockroachlabs.com/docs/v24.2/comment-on) | Associate a comment to a database, table, or column. |
| [`CREATE DATABASE`](https://docs.cockroachlabs.com/docs/v24.2/create-database) | Create a new database. |
| [`CREATE FUNCTION`](https://docs.cockroachlabs.com/docs/v24.2/create-function) | Create a [user-defined function](https://docs.cockroachlabs.com/docs/v24.2/user-defined-functions). |
| [`CREATE INDEX`](https://docs.cockroachlabs.com/docs/v24.2/create-index) | Create an index for a table. |
| [`CREATE PROCEDURE`](https://docs.cockroachlabs.com/docs/v24.2/create-procedure) | Create a [stored procedure](https://docs.cockroachlabs.com/docs/v24.2/stored-procedures). |
| [`CREATE SCHEMA`](https://docs.cockroachlabs.com/docs/v24.2/create-schema) | Create a user-defined schema. |
| [`CREATE SEQUENCE`](https://docs.cockroachlabs.com/docs/v24.2/create-sequence) | Create a new sequence. |
| [`CREATE TABLE`](https://docs.cockroachlabs.com/docs/v24.2/create-table) | Create a new table in a database. |
| [`CREATE TABLE AS`](https://docs.cockroachlabs.com/docs/v24.2/create-table-as) | Create a new table in a database using the results from a [selection query](https://docs.cockroachlabs.com/docs/v24.2/selection-queries). |
| [`CREATE TYPE`](https://docs.cockroachlabs.com/docs/v24.2/create-type) | Create a user-defined, [enumerated data type](https://docs.cockroachlabs.com/docs/v24.2/enum). |
| [`CREATE VIEW`](https://docs.cockroachlabs.com/docs/v24.2/create-view) | Create a new [view](https://docs.cockroachlabs.com/docs/v24.2/views) in a database. |
| [`DROP DATABASE`](https://docs.cockroachlabs.com/docs/v24.2/drop-database) | Remove a database and all its objects. |
| [`DROP FUNCTION`](https://docs.cockroachlabs.com/docs/v24.2/drop-function) | Remove a [user-defined function](https://docs.cockroachlabs.com/docs/v24.2/user-defined-functions) from a database. |
| [`DROP INDEX`](https://docs.cockroachlabs.com/docs/v24.2/drop-index) | Remove an index for a table. |
| [`DROP OWNED BY`](https://docs.cockroachlabs.com/docs/v24.2/drop-owned-by) | Drop all objects owned by and any [grants](https://docs.cockroachlabs.com/docs/v24.2/grant) on objects not owned by a [role](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#roles). |
| [`DROP PROCEDURE`](https://docs.cockroachlabs.com/docs/v24.2/drop-procedure) | Remove a [stored procedure](https://docs.cockroachlabs.com/docs/v24.2/stored-procedures). |
| [`DROP SCHEMA`](https://docs.cockroachlabs.com/docs/v24.2/drop-schema) | Drop a user-defined schema. |
| [`DROP SEQUENCE`](https://docs.cockroachlabs.com/docs/v24.2/drop-sequence) | Remove a sequence. |
| [`DROP TABLE`](https://docs.cockroachlabs.com/docs/v24.2/drop-table) | Remove a table. |
| [`DROP TYPE`](https://docs.cockroachlabs.com/docs/v24.2/drop-type) | Remove a user-defined, [enumerated data type](https://docs.cockroachlabs.com/docs/v24.2/enum). |
| [`DROP VIEW`](https://docs.cockroachlabs.com/docs/v24.2/drop-view) | Remove a view. |
| [`REFRESH`](https://docs.cockroachlabs.com/docs/v24.2/refresh) | Refresh the stored query results of a [materialized view](https://docs.cockroachlabs.com/docs/v24.2/views#materialized-views). |
| [`SHOW COLUMNS`](https://docs.cockroachlabs.com/docs/v24.2/show-columns) | View details about columns in a table. |
| [`SHOW CONSTRAINTS`](https://docs.cockroachlabs.com/docs/v24.2/show-constraints) | List constraints on a table. |
| [`SHOW CREATE`](https://docs.cockroachlabs.com/docs/v24.2/show-create) | View the `CREATE` statement for a database, function, sequence, table, or view. |
| [`SHOW DATABASES`](https://docs.cockroachlabs.com/docs/v24.2/show-databases) | List databases in the cluster. |
| [`SHOW DEFAULT SESSION VARIABLES FOR ROLE`](https://docs.cockroachlabs.com/docs/v24.2/show-default-session-variables-for-role) | List the values for updated [session variables](https://docs.cockroachlabs.com/docs/v24.2/set-vars) that are applied to a given [user or role](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#roles). |
| [`SHOW ENUMS`](https://docs.cockroachlabs.com/docs/v24.2/show-enums) | List user-defined, [enumerated data types](https://docs.cockroachlabs.com/docs/v24.2/enum) in a database. |
| [`SHOW FULL TABLE SCANS`](https://docs.cockroachlabs.com/docs/v24.2/show-full-table-scans) | List recent queries that used a full table scan. |
| [`SHOW INDEX`](https://docs.cockroachlabs.com/docs/v24.2/show-index) | View index information for a table or database. |
| [`SHOW LOCALITY`](https://docs.cockroachlabs.com/docs/v24.2/show-locality) | View the locality of the current node. |
| [`SHOW PARTITIONS`](https://docs.cockroachlabs.com/docs/v24.2/show-partitions) | List partitions in a database. |
| [`SHOW REGIONS`](https://docs.cockroachlabs.com/docs/v24.2/show-regions) | List the [cluster regions](https://docs.cockroachlabs.com/docs/v24.2/multiregion-overview#cluster-regions) or [database regions](https://docs.cockroachlabs.com/docs/v24.2/multiregion-overview#database-regions) in a [multi-region cluster](https://docs.cockroachlabs.com/docs/v24.2/multiregion-overview). |
| [`SHOW SUPER REGIONS`](https://docs.cockroachlabs.com/docs/v24.2/show-super-regions) | List the [super regions](https://docs.cockroachlabs.com/docs/v24.2/multiregion-overview#super-regions) associated with a database in a [multi-region cluster](https://docs.cockroachlabs.com/docs/v24.2/multiregion-overview). |
| [`SHOW SCHEMAS`](https://docs.cockroachlabs.com/docs/v24.2/show-schemas) | List the schemas in a database. |
| [`SHOW SEQUENCES`](https://docs.cockroachlabs.com/docs/v24.2/show-sequences) | List the sequences in a database. |
| [`SHOW TABLES`](https://docs.cockroachlabs.com/docs/v24.2/show-tables) | List tables or views in a database or virtual schema. |
| [`SHOW TYPES`](https://docs.cockroachlabs.com/docs/v24.2/show-types) | List user-defined [data types](https://docs.cockroachlabs.com/docs/v24.2/data-types) in a database. |
| [`SHOW RANGES`](https://docs.cockroachlabs.com/docs/v24.2/show-ranges) | Show range information for all data in a table or index. |
| [`SHOW RANGE FOR ROW`](https://docs.cockroachlabs.com/docs/v24.2/show-range-for-row) | Show range information for a single row in a table or index. |
| [`SHOW ZONE CONFIGURATIONS`](https://docs.cockroachlabs.com/docs/v24.2/show-zone-configurations) | List details about existing [replication zones](https://docs.cockroachlabs.com/docs/v24.2/configure-replication-zones). |

## Data manipulation statements

| Statement | Usage |
| - | - |
| [`CREATE TABLE AS`](https://docs.cockroachlabs.com/docs/v24.2/create-table-as) | Create a new table in a database using the results from a [selection query](https://docs.cockroachlabs.com/docs/v24.2/selection-queries). |
| [`COPY FROM`](https://docs.cockroachlabs.com/docs/v24.2/copy) | Copy data from a third-party client to a CockroachDB cluster. For compatibility with PostgreSQL drivers and ORMs, CockroachDB supports `COPY FROM` statements issued from third-party clients. To import data from files, use an [`IMPORT INTO`](https://docs.cockroachlabs.com/docs/v24.2/import-into) statement instead. |
| [`DELETE`](https://docs.cockroachlabs.com/docs/v24.2/delete) | Delete specific rows from a table. |
| [`EXPORT`](https://docs.cockroachlabs.com/docs/v24.2/export) | Export an entire table's data, or the results of a `SELECT` statement, to CSV files. |
| [`IMPORT INTO`](https://docs.cockroachlabs.com/docs/v24.2/import-into) | Bulk-insert CSV data into an existing table. |
| [`INSERT`](https://docs.cockroachlabs.com/docs/v24.2/insert) | Insert rows into a table. |
| [`SELECT`](https://docs.cockroachlabs.com/docs/v24.2/select-clause) | Select specific rows and columns from a table and optionally compute derived values. |
| [`SELECT FOR UPDATE`](https://docs.cockroachlabs.com/docs/v24.2/select-for-update) | Order transactions by controlling concurrent access to one or more rows of a table. |
| [`TABLE`](https://docs.cockroachlabs.com/docs/v24.2/selection-queries#table-clause) | Select all rows and columns from a table. |
| [`TRUNCATE`](https://docs.cockroachlabs.com/docs/v24.2/truncate) | Delete all rows from specified tables. |
| [`UPDATE`](https://docs.cockroachlabs.com/docs/v24.2/update) | Update rows in a table. |
| [`UPSERT`](https://docs.cockroachlabs.com/docs/v24.2/upsert) | Insert rows that do not violate uniqueness constraints; update rows that do. |
| [`VALUES`](https://docs.cockroachlabs.com/docs/v24.2/selection-queries#values-clause) | Return rows containing specific values. |

## Data control statements

| Statement | Usage |
| - | - |
| [`CREATE ROLE`](https://docs.cockroachlabs.com/docs/v24.2/create-role) | Create SQL [roles](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#users-and-roles), which are groups containing any number of roles and users as members. |
| [`CREATE USER`](https://docs.cockroachlabs.com/docs/v24.2/create-user) | Create SQL users, which lets you control [privileges](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#managing-privileges) on your databases and tables. |
| [`DROP ROLE`](https://docs.cockroachlabs.com/docs/v24.2/drop-role) | Remove one or more SQL [roles](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#users-and-roles). |
| [`DROP USER`](https://docs.cockroachlabs.com/docs/v24.2/drop-user) | Remove one or more SQL users. |
| [`GRANT`](https://docs.cockroachlabs.com/docs/v24.2/grant) | Grant privileges to [users and roles](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#users-and-roles), or add a [role](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#users-and-roles) or [user](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#create-and-manage-users) as a member to a role. |
| [`REASSIGN OWNED`](https://docs.cockroachlabs.com/docs/v24.2/reassign-owned) | Change the [ownership](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#object-ownership) of all database objects in the current database that are currently owned by a specific [role](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#roles) or [user](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#sql-users). |
| [`REVOKE`](https://docs.cockroachlabs.com/docs/v24.2/revoke) | Revoke privileges from [users](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#create-and-manage-users) or [roles](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#users-and-roles), or revoke a [role](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#users-and-roles) or [user's](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#create-and-manage-users) membership to a role. |
| [`SHOW GRANTS`](https://docs.cockroachlabs.com/docs/v24.2/show-grants) | View privileges granted to users. |
| [`SHOW ROLES`](https://docs.cockroachlabs.com/docs/v24.2/show-roles) | Lists the roles for all databases. |
| [`SHOW USERS`](https://docs.cockroachlabs.com/docs/v24.2/show-users) | Lists the users for all databases. |
| [`SHOW DEFAULT PRIVILEGES`](https://docs.cockroachlabs.com/docs/v24.2/show-default-privileges) | Show the default privileges for objects created by specific roles/users in the current database. |

## Transaction control statements

| Statement | Usage |
| - | - |
| [`BEGIN`](https://docs.cockroachlabs.com/docs/v24.2/begin-transaction) | Initiate a [transaction](https://docs.cockroachlabs.com/docs/v24.2/transactions). |
| [`CALL`](https://docs.cockroachlabs.com/docs/v24.2/call) | Call a [stored procedure](https://docs.cockroachlabs.com/docs/v24.2/stored-procedures). |
| [`COMMIT`](https://docs.cockroachlabs.com/docs/v24.2/commit-transaction) | Commit the current [transaction](https://docs.cockroachlabs.com/docs/v24.2/transactions). |
| [`SAVEPOINT`](https://docs.cockroachlabs.com/docs/v24.2/savepoint) | Start a [nested transaction](https://docs.cockroachlabs.com/docs/v24.2/transactions#nested-transactions). |
| [`RELEASE SAVEPOINT`](https://docs.cockroachlabs.com/docs/v24.2/release-savepoint) | Commit a [nested transaction](https://docs.cockroachlabs.com/docs/v24.2/transactions#nested-transactions). |
| [`ROLLBACK TO SAVEPOINT`](https://docs.cockroachlabs.com/docs/v24.2/rollback-transaction#rollback-a-nested-transaction) | Roll back and restart the [nested transaction](https://docs.cockroachlabs.com/docs/v24.2/transactions#nested-transactions) started at the corresponding `SAVEPOINT` statement. |
| [`ROLLBACK`](https://docs.cockroachlabs.com/docs/v24.2/rollback-transaction) | Roll back the current [transaction](https://docs.cockroachlabs.com/docs/v24.2/transactions) and all of its [nested transaction](https://docs.cockroachlabs.com/docs/v24.2/transactions#nested-transactions), discarding all transactional updates made by statements inside the transaction. |
| [`SET TRANSACTION`](https://docs.cockroachlabs.com/docs/v24.2/set-transaction) | Set the priority for the session or for an individual [transaction](https://docs.cockroachlabs.com/docs/v24.2/transactions). |
| [`SHOW`](https://docs.cockroachlabs.com/docs/v24.2/show-vars) | View the current [transaction settings](https://docs.cockroachlabs.com/docs/v24.2/transactions). |
| [`SHOW TRANSACTIONS`](https://docs.cockroachlabs.com/docs/v24.2/show-transactions) | View all currently active transactions across the cluster or on the local node. |

## Session management statements

| Statement | Usage |
| - | - |
| [`RESET session variable`](https://docs.cockroachlabs.com/docs/v24.2/reset-vars) | Reset a session variable to its default value. |
| [`SET session variable`](https://docs.cockroachlabs.com/docs/v24.2/set-vars) | Set a current session variable. |
| [`SET TRANSACTION`](https://docs.cockroachlabs.com/docs/v24.2/set-transaction) | Set the priority for an individual [transaction](https://docs.cockroachlabs.com/docs/v24.2/transactions). |
| [`SHOW TRACE FOR SESSION`](https://docs.cockroachlabs.com/docs/v24.2/show-trace) | Return details about how CockroachDB executed a statement or series of statements recorded during a session. |
| [`SHOW session variable`](https://docs.cockroachlabs.com/docs/v24.2/show-vars) | List the current session or transaction settings. |

## Cluster management statements

| Statement | Usage |
| - | - |
| [`RESET CLUSTER SETTING`](https://docs.cockroachlabs.com/docs/v24.2/reset-cluster-setting) | Reset a cluster setting to its default value. |
| [`SET CLUSTER SETTING`](https://docs.cockroachlabs.com/docs/v24.2/set-cluster-setting) | Set a cluster-wide setting. |
| [`SHOW ALL CLUSTER SETTINGS`](https://docs.cockroachlabs.com/docs/v24.2/show-cluster-setting) | List the current cluster-wide settings. |
| [`SHOW SESSIONS`](https://docs.cockroachlabs.com/docs/v24.2/show-sessions) | List details about currently active sessions. |
| [`CANCEL SESSION`](https://docs.cockroachlabs.com/docs/v24.2/cancel-session) | Cancel a long-running session. |

## Query management statements

| Statement | Usage |
| - | - |
| [`CANCEL QUERY`](https://docs.cockroachlabs.com/docs/v24.2/cancel-query) | Cancel a running SQL query. |
| [`SHOW STATEMENTS`/`SHOW QUERIES`](https://docs.cockroachlabs.com/docs/v24.2/show-statements) | List details about current active SQL queries. |

## Query planning statements

| Statement | Usage |
| - | - |
| [`CREATE STATISTICS`](https://docs.cockroachlabs.com/docs/v24.2/create-statistics) | Create table statistics for the [cost-based optimizer](https://docs.cockroachlabs.com/docs/v24.2/cost-based-optimizer) to use. |
| [`EXPLAIN`](https://docs.cockroachlabs.com/docs/v24.2/explain) | View debugging and analysis details for a statement that operates over tabular data. |
| [`EXPLAIN ANALYZE`](https://docs.cockroachlabs.com/docs/v24.2/explain-analyze) | Execute the query and generate a physical query plan with execution statistics. |
| [`SHOW STATISTICS`](https://docs.cockroachlabs.com/docs/v24.2/show-statistics) | List table statistics used by the [cost-based optimizer](https://docs.cockroachlabs.com/docs/v24.2/cost-based-optimizer). |

## Job management statements

Jobs in CockroachDB represent tasks that might not complete immediately, such as schema changes or  backups or restores.

| Statement | Usage |
| - | - |
| [`CANCEL JOB`](https://docs.cockroachlabs.com/docs/v24.2/cancel-job) | Cancel a `BACKUP`, `RESTORE`, `IMPORT`, or `CHANGEFEED` job. |
| [`PAUSE JOB`](https://docs.cockroachlabs.com/docs/v24.2/pause-job) | Pause a `BACKUP`, `RESTORE`, `IMPORT`, or `CHANGEFEED` job. |
| [`RESUME JOB`](https://docs.cockroachlabs.com/docs/v24.2/resume-job) | Resume a paused `BACKUP`, `RESTORE`, `IMPORT`, or `CHANGEFEED` job. |
| [`SHOW JOBS`](https://docs.cockroachlabs.com/docs/v24.2/show-jobs) | View information on jobs. |

## Backup and restore statements

| Statement | Usage |
| - | - |
| [`BACKUP`](https://docs.cockroachlabs.com/docs/v24.2/backup) | Create disaster recovery backups of clusters, databases, and tables. |
| [`RESTORE`](https://docs.cockroachlabs.com/docs/v24.2/restore) | Restore clusters, databases, and tables using your backups. |
| [`SHOW BACKUP`](https://docs.cockroachlabs.com/docs/v24.2/show-backup) | List the contents of a backup. |
| [`CREATE SCHEDULE FOR BACKUP`](https://docs.cockroachlabs.com/docs/v24.2/create-schedule-for-backup) | Create a schedule for periodic backups. |
| [`ALTER BACKUP SCHEDULE`](https://docs.cockroachlabs.com/docs/v24.2/alter-backup-schedule) | Modify an existing backup schedule. |
| [`SHOW SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/show-schedules) | View information on backup schedules. |
| [`PAUSE SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/pause-schedules) | Pause backup schedules. |
| [`RESUME SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/resume-schedules) | Resume paused backup schedules. |
| [`DROP SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/drop-schedules) | Drop backup schedules. |
| [`ALTER BACKUP`](https://docs.cockroachlabs.com/docs/v24.2/alter-backup) | Add a new [KMS encryption key](https://docs.cockroachlabs.com/docs/v24.2/take-and-restore-encrypted-backups#use-key-management-service) to an encrypted backup. |

## Changefeed statements

[Change data capture](https://docs.cockroachlabs.com/docs/v24.2/change-data-capture-overview) (CDC) provides an  and core version of row-level change subscriptions for downstream processing.

| Statement | Usage |
| - | - |
| [`CREATE CHANGEFEED`](https://docs.cockroachlabs.com/docs/v24.2/create-changefeed) | Create a new changefeed to stream row-level changes in a configurable format to a configurable sink (e.g, [Kafka](https://docs.cockroachlabs.com/docs/v24.2/changefeed-sinks#kafka), [cloud storage](https://docs.cockroachlabs.com/docs/v24.2/changefeed-sinks#cloud-storage-sink)). |
| [`CREATE SCHEDULE FOR CHANGEFEED`](https://docs.cockroachlabs.com/docs/v24.2/create-schedule-for-changefeed) | Create a scheduled changefeed to export data out of CockroachDB using an initial scan. to a configurable sink (e.g, [Kafka](https://docs.cockroachlabs.com/docs/v24.2/changefeed-sinks#kafka), [cloud storage](https://docs.cockroachlabs.com/docs/v24.2/changefeed-sinks#cloud-storage-sink)). |
| [`EXPERIMENTAL CHANGEFEED FOR`](https://docs.cockroachlabs.com/docs/v24.2/changefeed-for) | (Core) Create a new changefeed to stream row-level changes to the client indefinitely until the underlying connection is closed or the changefeed is canceled. |
| [`ALTER CHANGEFEED`](https://docs.cockroachlabs.com/docs/v24.2/alter-changefeed) | Modify an existing changefeed. |

## External resource statements

| Statement | Usage |
| - | - |
| [`CREATE EXTERNAL CONNECTION`](https://docs.cockroachlabs.com/docs/v24.2/create-external-connection) | Create an external connection, which represents a provider-specific URI, to interact with resources that are external from CockroachDB. |
| [`SHOW CREATE EXTERNAL CONNECTION`](https://docs.cockroachlabs.com/docs/v24.2/show-create-external-connection) | Display the connection name and the creation statements for active external connections. |
| [`DROP EXTERNAL CONNECTION`](https://docs.cockroachlabs.com/docs/v24.2/drop-external-connection) | Drop an external connection. |