# CockroachDB: CockroachDB v26.1

## v26.1

- [CockroachDB / v26.1 / Docs (278 pages)](https://docs.cockroachlabs.com/_llms/cockroach-db/v26-1/docs.md): Documentation for CockroachDB / v26.1 / Docs.

### Migrate

- [Migration Overview](https://docs.cockroachlabs.com/docs/molt/migration-overview.md)
- [Migration Best Practices](https://docs.cockroachlabs.com/docs/molt/migration-strategy.md)

#### Migration Considerations

- [Migration Considerations](https://docs.cockroachlabs.com/docs/molt/migration-considerations.md)
- [Migration Granularity](https://docs.cockroachlabs.com/docs/molt/migration-considerations-granularity.md)
- [Continuous Replication](https://docs.cockroachlabs.com/docs/molt/migration-considerations-replication.md)
- [Data Transformation Strategy](https://docs.cockroachlabs.com/docs/molt/migration-considerations-transformation.md)
- [Validation Strategy](https://docs.cockroachlabs.com/docs/molt/migration-considerations-validation.md)
- [Rollback Plan](https://docs.cockroachlabs.com/docs/molt/migration-considerations-rollback.md)

#### MOLT Tools

- [MOLT Verify](https://docs.cockroachlabs.com/docs/molt/molt-verify.md)

##### Fetch

- [MOLT Fetch](https://docs.cockroachlabs.com/docs/molt/molt-fetch.md)
- [MOLT Fetch Installation](https://docs.cockroachlabs.com/docs/molt/molt-fetch-installation.md)
- [MOLT Fetch Commands and Flags](https://docs.cockroachlabs.com/docs/molt/molt-fetch-commands-and-flags.md)
- [MOLT Fetch Metrics](https://docs.cockroachlabs.com/docs/molt/molt-fetch-monitoring.md)
- [MOLT Fetch Best Practices](https://docs.cockroachlabs.com/docs/molt/molt-fetch-best-practices.md)
- [MOLT Fetch Troubleshooting](https://docs.cockroachlabs.com/docs/molt/molt-fetch-troubleshooting.md)

##### Replicator

- [MOLT Replicator](https://docs.cockroachlabs.com/docs/molt/molt-replicator.md)
- [MOLT Replicator Installation](https://docs.cockroachlabs.com/docs/molt/molt-replicator-installation.md)
- [MOLT Replicator Commands and Flags](https://docs.cockroachlabs.com/docs/molt/replicator-flags.md)
- [MOLT Replicator Metrics](https://docs.cockroachlabs.com/docs/molt/replicator-metrics.md)
- [MOLT Replicator Best Practices](https://docs.cockroachlabs.com/docs/molt/molt-replicator-best-practices.md)
- [MOLT Replicator Troubleshooting](https://docs.cockroachlabs.com/docs/molt/molt-replicator-troubleshooting.md)

###### Userscripts

- [Userscript Overview](https://docs.cockroachlabs.com/docs/molt/userscript-overview.md)
- [Userscript Quickstart](https://docs.cockroachlabs.com/docs/molt/userscript-quickstart.md)
- [Userscript API](https://docs.cockroachlabs.com/docs/molt/userscript-api.md)
- [Userscript Cookbook](https://docs.cockroachlabs.com/docs/molt/userscript-cookbook.md)
- [Userscript Metrics](https://docs.cockroachlabs.com/docs/molt/userscript-metrics.md)

#### Common Migration Approaches

##### Classic Bulk Load Migration

- [Classic Bulk Load Migration](https://docs.cockroachlabs.com/docs/molt/migration-approach-classic-bulk-load.md)
- [Classic Bulk Load Migration from PostgreSQL](https://docs.cockroachlabs.com/docs/molt/classic-bulk-load-postgres.md)
- [Classic Bulk Load Migration from MySQL](https://docs.cockroachlabs.com/docs/molt/classic-bulk-load-mysql.md)
- [Classic Bulk Load Migration from Oracle](https://docs.cockroachlabs.com/docs/molt/classic-bulk-load-oracle.md)

##### Phased Bulk Load Migration

- [Phased Bulk Load Migration](https://docs.cockroachlabs.com/docs/molt/migration-approach-phased-bulk-load.md)
- [Phased Bulk Load Migration from PostgreSQL](https://docs.cockroachlabs.com/docs/molt/phased-bulk-load-postgres.md)
- [Phased Bulk Load Migration from MySQL](https://docs.cockroachlabs.com/docs/molt/phased-bulk-load-mysql.md)
- [Phased Bulk Load Migration from Oracle](https://docs.cockroachlabs.com/docs/molt/phased-bulk-load-oracle.md)

##### Delta Migration

- [Delta Migration](https://docs.cockroachlabs.com/docs/molt/migration-approach-delta.md)
- [Delta Migration from PostgreSQL](https://docs.cockroachlabs.com/docs/molt/delta-migration-postgres.md)
- [Delta Migration from MySQL](https://docs.cockroachlabs.com/docs/molt/delta-migration-mysql.md)
- [Delta Migration from Oracle](https://docs.cockroachlabs.com/docs/molt/delta-migration-oracle.md)

##### Phased Delta Migration with Failback Replication

- [Phased Delta Migration with Failback Replication](https://docs.cockroachlabs.com/docs/molt/migration-approach-phased-delta-failback.md)
- [Phased Delta Migration with Failback Replication from PostgreSQL](https://docs.cockroachlabs.com/docs/molt/phased-delta-failback-postgres.md)
- [Phased Delta Migration with Failback Replication from MySQL](https://docs.cockroachlabs.com/docs/molt/phased-delta-failback-mysql.md)
- [Phased Delta Migration with Failback Replication from Oracle](https://docs.cockroachlabs.com/docs/molt/phased-delta-failback-oracle.md)

#### Third-Party Migration Tools

- [Migrate with AWS Database Migration Service (DMS)](https://docs.cockroachlabs.com/docs/v26.1/aws-dms.md)
- [Migrate and Replicate Data with Qlik Replicate](https://docs.cockroachlabs.com/docs/v26.1/qlik.md)
- [Migrate and Replicate Data with Striim](https://docs.cockroachlabs.com/docs/v26.1/striim.md)
- [Migrate and Replicate Data with Oracle GoldenGate](https://docs.cockroachlabs.com/docs/v26.1/goldengate.md)
- [Migrate Data with Debezium](https://docs.cockroachlabs.com/docs/v26.1/debezium.md)

#### Migrate Data Types

- [Migrate from CSV](https://docs.cockroachlabs.com/docs/v26.1/migrate-from-csv.md)
- [Migrate from Avro](https://docs.cockroachlabs.com/docs/v26.1/migrate-from-avro.md)
- [Migrate from Shapefiles](https://docs.cockroachlabs.com/docs/v26.1/migrate-from-shapefiles.md)
- [Migrate from OpenStreetMap](https://docs.cockroachlabs.com/docs/v26.1/migrate-from-openstreetmap.md)
- [Migrate from GeoJSON](https://docs.cockroachlabs.com/docs/v26.1/migrate-from-geojson.md)
- [Migrate from GeoPackage](https://docs.cockroachlabs.com/docs/v26.1/migrate-from-geopackage.md)
- [Import Performance Best Practices](https://docs.cockroachlabs.com/docs/v26.1/import-performance-best-practices.md)

### SQL

- [Functions and Operators](https://docs.cockroachlabs.com/docs/v26.1/functions-and-operators.md)
- [Session Variables](https://docs.cockroachlabs.com/docs/v26.1/session-variables.md)
- [PL/pgSQL](https://docs.cockroachlabs.com/docs/v26.1/plpgsql.md)

#### Statements

- [SQL Statements](https://docs.cockroachlabs.com/docs/v26.1/sql-statements.md)
- [ALTER BACKUP](https://docs.cockroachlabs.com/docs/v26.1/alter-backup.md)
- [ALTER BACKUP SCHEDULE](https://docs.cockroachlabs.com/docs/v26.1/alter-backup-schedule.md)
- [ALTER CHANGEFEED](https://docs.cockroachlabs.com/docs/v26.1/alter-changefeed.md)
- [ALTER DATABASE](https://docs.cockroachlabs.com/docs/v26.1/alter-database.md)
- [ALTER DEFAULT PRIVILEGES](https://docs.cockroachlabs.com/docs/v26.1/alter-default-privileges.md)
- [ALTER EXTERNAL CONNECTION](https://docs.cockroachlabs.com/docs/v26.1/alter-external-connection.md)
- [ALTER FUNCTION](https://docs.cockroachlabs.com/docs/v26.1/alter-function.md)
- [ALTER INDEX](https://docs.cockroachlabs.com/docs/v26.1/alter-index.md)
- [ALTER JOB](https://docs.cockroachlabs.com/docs/v26.1/alter-job.md)
- [ALTER PARTITION](https://docs.cockroachlabs.com/docs/v26.1/alter-partition.md)
- [ALTER POLICY](https://docs.cockroachlabs.com/docs/v26.1/alter-policy.md)
- [ALTER PROCEDURE](https://docs.cockroachlabs.com/docs/v26.1/alter-procedure.md)
- [ALTER RANGE](https://docs.cockroachlabs.com/docs/v26.1/alter-range.md)
- [ALTER ROLE](https://docs.cockroachlabs.com/docs/v26.1/alter-role.md)
- [ALTER SCHEMA](https://docs.cockroachlabs.com/docs/v26.1/alter-schema.md)
- [ALTER SEQUENCE](https://docs.cockroachlabs.com/docs/v26.1/alter-sequence.md)
- [ALTER TABLE](https://docs.cockroachlabs.com/docs/v26.1/alter-table.md)
- [ALTER TYPE](https://docs.cockroachlabs.com/docs/v26.1/alter-type.md)
- [ALTER USER](https://docs.cockroachlabs.com/docs/v26.1/alter-user.md)
- [ALTER VIEW](https://docs.cockroachlabs.com/docs/v26.1/alter-view.md)
- [ALTER VIRTUAL CLUSTER](https://docs.cockroachlabs.com/docs/v26.1/alter-virtual-cluster.md)
- [BACKUP](https://docs.cockroachlabs.com/docs/v26.1/backup.md)
- [BEGIN](https://docs.cockroachlabs.com/docs/v26.1/begin-transaction.md)
- [CALL](https://docs.cockroachlabs.com/docs/v26.1/call.md)
- [CANCEL JOB](https://docs.cockroachlabs.com/docs/v26.1/cancel-job.md)
- [CANCEL QUERY](https://docs.cockroachlabs.com/docs/v26.1/cancel-query.md)
- [CANCEL SESSION](https://docs.cockroachlabs.com/docs/v26.1/cancel-session.md)
- [CHECK EXTERNAL CONNECTION](https://docs.cockroachlabs.com/docs/v26.1/check-external-connection.md)
- [COMMENT ON](https://docs.cockroachlabs.com/docs/v26.1/comment-on.md)
- [COMMIT](https://docs.cockroachlabs.com/docs/v26.1/commit-transaction.md)
- [COPY](https://docs.cockroachlabs.com/docs/v26.1/copy.md)
- [CREATE CHANGEFEED](https://docs.cockroachlabs.com/docs/v26.1/create-changefeed.md)
- [CREATE DATABASE](https://docs.cockroachlabs.com/docs/v26.1/create-database.md)
- [CREATE EXTERNAL CONNECTION](https://docs.cockroachlabs.com/docs/v26.1/create-external-connection.md)
- [CREATE FUNCTION](https://docs.cockroachlabs.com/docs/v26.1/create-function.md)
- [CREATE INDEX](https://docs.cockroachlabs.com/docs/v26.1/create-index.md)
- [CREATE LOGICALLY REPLICATED](https://docs.cockroachlabs.com/docs/v26.1/create-logically-replicated.md)
- [CREATE LOGICAL REPLICATION STREAM](https://docs.cockroachlabs.com/docs/v26.1/create-logical-replication-stream.md)
- [CREATE POLICY](https://docs.cockroachlabs.com/docs/v26.1/create-policy.md)
- [CREATE PROCEDURE](https://docs.cockroachlabs.com/docs/v26.1/create-procedure.md)
- [CREATE ROLE](https://docs.cockroachlabs.com/docs/v26.1/create-role.md)
- [CREATE SCHEDULE FOR BACKUP](https://docs.cockroachlabs.com/docs/v26.1/create-schedule-for-backup.md)
- [CREATE SCHEDULE FOR CHANGEFEED](https://docs.cockroachlabs.com/docs/v26.1/create-schedule-for-changefeed.md)
- [CREATE SCHEMA](https://docs.cockroachlabs.com/docs/v26.1/create-schema.md)
- [CREATE SEQUENCE](https://docs.cockroachlabs.com/docs/v26.1/create-sequence.md)
- [CREATE STATISTICS](https://docs.cockroachlabs.com/docs/v26.1/create-statistics.md)
- [CREATE TABLE](https://docs.cockroachlabs.com/docs/v26.1/create-table.md)
- [CREATE TABLE AS](https://docs.cockroachlabs.com/docs/v26.1/create-table-as.md)
- [CREATE TRIGGER](https://docs.cockroachlabs.com/docs/v26.1/create-trigger.md)
- [CREATE TYPE](https://docs.cockroachlabs.com/docs/v26.1/create-type.md)
- [CREATE USER](https://docs.cockroachlabs.com/docs/v26.1/create-user.md)
- [CREATE VIEW](https://docs.cockroachlabs.com/docs/v26.1/create-view.md)
- [CREATE VIRTUAL CLUSTER](https://docs.cockroachlabs.com/docs/v26.1/create-virtual-cluster.md)
- [DELETE](https://docs.cockroachlabs.com/docs/v26.1/delete.md)
- [DO](https://docs.cockroachlabs.com/docs/v26.1/do.md)
- [DROP DATABASE](https://docs.cockroachlabs.com/docs/v26.1/drop-database.md)
- [DROP EXTERNAL CONNECTION](https://docs.cockroachlabs.com/docs/v26.1/drop-external-connection.md)
- [DROP FUNCTION](https://docs.cockroachlabs.com/docs/v26.1/drop-function.md)
- [DROP OWNED BY](https://docs.cockroachlabs.com/docs/v26.1/drop-owned-by.md)
- [DROP POLICY](https://docs.cockroachlabs.com/docs/v26.1/drop-policy.md)
- [DROP TRIGGER](https://docs.cockroachlabs.com/docs/v26.1/drop-trigger.md)
- [DROP TYPE](https://docs.cockroachlabs.com/docs/v26.1/drop-type.md)
- [DROP INDEX](https://docs.cockroachlabs.com/docs/v26.1/drop-index.md)
- [DROP PROCEDURE](https://docs.cockroachlabs.com/docs/v26.1/drop-procedure.md)
- [DROP ROLE](https://docs.cockroachlabs.com/docs/v26.1/drop-role.md)
- [DROP SCHEDULES](https://docs.cockroachlabs.com/docs/v26.1/drop-schedules.md)
- [DROP SCHEMA](https://docs.cockroachlabs.com/docs/v26.1/drop-schema.md)
- [DROP SEQUENCE](https://docs.cockroachlabs.com/docs/v26.1/drop-sequence.md)
- [DROP TABLE](https://docs.cockroachlabs.com/docs/v26.1/drop-table.md)
- [DROP USER](https://docs.cockroachlabs.com/docs/v26.1/drop-user.md)
- [DROP VIEW](https://docs.cockroachlabs.com/docs/v26.1/drop-view.md)
- [DROP VIRTUAL CLUSTER](https://docs.cockroachlabs.com/docs/v26.1/drop-virtual-cluster.md)
- [EXPERIMENTAL CHANGEFEED FOR](https://docs.cockroachlabs.com/docs/v26.1/changefeed-for.md)
- [EXPLAIN](https://docs.cockroachlabs.com/docs/v26.1/explain.md)
- [EXPLAIN ANALYZE](https://docs.cockroachlabs.com/docs/v26.1/explain-analyze.md)
- [EXPORT](https://docs.cockroachlabs.com/docs/v26.1/export.md)
- [GRANT](https://docs.cockroachlabs.com/docs/v26.1/grant.md)
- [IMPORT INTO](https://docs.cockroachlabs.com/docs/v26.1/import-into.md)
- [INSERT](https://docs.cockroachlabs.com/docs/v26.1/insert.md)
- [INSPECT](https://docs.cockroachlabs.com/docs/v26.1/inspect.md)
- [JOIN expressions](https://docs.cockroachlabs.com/docs/v26.1/joins.md)
- [Limit Query Results](https://docs.cockroachlabs.com/docs/v26.1/limit-offset.md)
- [ORDER BY](https://docs.cockroachlabs.com/docs/v26.1/order-by.md)
- [PAUSE JOB](https://docs.cockroachlabs.com/docs/v26.1/pause-job.md)
- [PAUSE SCHEDULES](https://docs.cockroachlabs.com/docs/v26.1/pause-schedules.md)
- [REASSIGN OWNED](https://docs.cockroachlabs.com/docs/v26.1/reassign-owned.md)
- [REFRESH](https://docs.cockroachlabs.com/docs/v26.1/refresh.md)
- [RELEASE SAVEPOINT](https://docs.cockroachlabs.com/docs/v26.1/release-savepoint.md)
- [RESET CLUSTER SETTING](https://docs.cockroachlabs.com/docs/v26.1/reset-cluster-setting.md)
- [RESET {session variable}](https://docs.cockroachlabs.com/docs/v26.1/reset-vars.md)
- [RESTORE](https://docs.cockroachlabs.com/docs/v26.1/restore.md)
- [RESUME JOB](https://docs.cockroachlabs.com/docs/v26.1/resume-job.md)
- [RESUME SCHEDULES](https://docs.cockroachlabs.com/docs/v26.1/resume-schedules.md)
- [REVOKE](https://docs.cockroachlabs.com/docs/v26.1/revoke.md)
- [ROLLBACK](https://docs.cockroachlabs.com/docs/v26.1/rollback-transaction.md)
- [SAVEPOINT](https://docs.cockroachlabs.com/docs/v26.1/savepoint.md)
- [Simple SELECT Clause](https://docs.cockroachlabs.com/docs/v26.1/select-clause.md)
- [FOR UPDATE and FOR SHARE](https://docs.cockroachlabs.com/docs/v26.1/select-for-update.md)
- [SET CLUSTER SETTING](https://docs.cockroachlabs.com/docs/v26.1/set-cluster-setting.md)
- [SET {session variable}](https://docs.cockroachlabs.com/docs/v26.1/set-vars.md)
- [SET TRANSACTION](https://docs.cockroachlabs.com/docs/v26.1/set-transaction.md)
- [SHOW BACKUP](https://docs.cockroachlabs.com/docs/v26.1/show-backup.md)
- [SHOW CLUSTER SETTING](https://docs.cockroachlabs.com/docs/v26.1/show-cluster-setting.md)
- [SHOW COLUMNS](https://docs.cockroachlabs.com/docs/v26.1/show-columns.md)
- [SHOW CONSTRAINTS](https://docs.cockroachlabs.com/docs/v26.1/show-constraints.md)
- [SHOW CREATE](https://docs.cockroachlabs.com/docs/v26.1/show-create.md)
- [SHOW CREATE EXTERNAL CONNECTION](https://docs.cockroachlabs.com/docs/v26.1/show-create-external-connection.md)
- [SHOW CREATE SCHEDULE](https://docs.cockroachlabs.com/docs/v26.1/show-create-schedule.md)
- [SHOW DATABASES](https://docs.cockroachlabs.com/docs/v26.1/show-databases.md)
- [SHOW DEFAULT PRIVILEGES](https://docs.cockroachlabs.com/docs/v26.1/show-default-privileges.md)
- [SHOW DEFAULT SESSION VARIABLES FOR ROLE](https://docs.cockroachlabs.com/docs/v26.1/show-default-session-variables-for-role.md)
- [SHOW ENUMS](https://docs.cockroachlabs.com/docs/v26.1/show-enums.md)
- [SHOW EXTERNAL CONNECTION](https://docs.cockroachlabs.com/docs/v26.1/show-external-connection.md)
- [SHOW FULL TABLE SCANS](https://docs.cockroachlabs.com/docs/v26.1/show-full-table-scans.md)
- [SHOW GRANTS](https://docs.cockroachlabs.com/docs/v26.1/show-grants.md)
- [SHOW INDEX](https://docs.cockroachlabs.com/docs/v26.1/show-index.md)
- [SHOW INSPECT ERRORS](https://docs.cockroachlabs.com/docs/v26.1/show-inspect-errors.md)
- [SHOW JOBS](https://docs.cockroachlabs.com/docs/v26.1/show-jobs.md)
- [SHOW LOCALITY](https://docs.cockroachlabs.com/docs/v26.1/show-locality.md)
- [SHOW LOGICAL REPLICATION JOBS](https://docs.cockroachlabs.com/docs/v26.1/show-logical-replication-jobs.md)
- [SHOW PARTITIONS](https://docs.cockroachlabs.com/docs/v26.1/show-partitions.md)
- [SHOW POLICIES](https://docs.cockroachlabs.com/docs/v26.1/show-policies.md)
- [SHOW RANGES](https://docs.cockroachlabs.com/docs/v26.1/show-ranges.md)
- [SHOW RANGE FOR ROW](https://docs.cockroachlabs.com/docs/v26.1/show-range-for-row.md)
- [SHOW REGIONS](https://docs.cockroachlabs.com/docs/v26.1/show-regions.md)
- [SHOW {session variable}](https://docs.cockroachlabs.com/docs/v26.1/show-vars.md)
- [SHOW SUPER REGIONS](https://docs.cockroachlabs.com/docs/v26.1/show-super-regions.md)
- [SHOW SYSTEM GRANTS](https://docs.cockroachlabs.com/docs/v26.1/show-system-grants.md)
- [SHOW ROLES](https://docs.cockroachlabs.com/docs/v26.1/show-roles.md)
- [SHOW SCHEDULES](https://docs.cockroachlabs.com/docs/v26.1/show-schedules.md)
- [SHOW SCHEMAS](https://docs.cockroachlabs.com/docs/v26.1/show-schemas.md)
- [SHOW SEQUENCES](https://docs.cockroachlabs.com/docs/v26.1/show-sequences.md)
- [SHOW SESSIONS](https://docs.cockroachlabs.com/docs/v26.1/show-sessions.md)
- [SHOW STATEMENT HINTS](https://docs.cockroachlabs.com/docs/v26.1/show-statement-hints.md)
- [SHOW STATEMENTS](https://docs.cockroachlabs.com/docs/v26.1/show-statements.md)
- [SHOW STATISTICS](https://docs.cockroachlabs.com/docs/v26.1/show-statistics.md)
- [SHOW SAVEPOINT STATUS](https://docs.cockroachlabs.com/docs/v26.1/show-savepoint-status.md)
- [SHOW TABLES](https://docs.cockroachlabs.com/docs/v26.1/show-tables.md)
- [SHOW TRACE FOR SESSION](https://docs.cockroachlabs.com/docs/v26.1/show-trace.md)
- [SHOW TRANSACTIONS](https://docs.cockroachlabs.com/docs/v26.1/show-transactions.md)
- [SHOW TRIGGERS](https://docs.cockroachlabs.com/docs/v26.1/show-triggers.md)
- [SHOW TYPES](https://docs.cockroachlabs.com/docs/v26.1/show-types.md)
- [SHOW USERS](https://docs.cockroachlabs.com/docs/v26.1/show-users.md)
- [SHOW VIRTUAL CLUSTER](https://docs.cockroachlabs.com/docs/v26.1/show-virtual-cluster.md)
- [SHOW ZONE CONFIGURATIONS](https://docs.cockroachlabs.com/docs/v26.1/show-zone-configurations.md)
- [TRUNCATE](https://docs.cockroachlabs.com/docs/v26.1/truncate.md)
- [UPDATE](https://docs.cockroachlabs.com/docs/v26.1/update.md)
- [UPSERT](https://docs.cockroachlabs.com/docs/v26.1/upsert.md)
- [WITH (storage parameter)](https://docs.cockroachlabs.com/docs/v26.1/with-storage-parameter.md)

#### Syntax

- [Keywords & Identifiers](https://docs.cockroachlabs.com/docs/v26.1/keywords-and-identifiers.md)
- [Constants](https://docs.cockroachlabs.com/docs/v26.1/sql-constants.md)
- [Selection Queries](https://docs.cockroachlabs.com/docs/v26.1/selection-queries.md)
- [Cursors](https://docs.cockroachlabs.com/docs/v26.1/cursors.md)
- [Table Expressions](https://docs.cockroachlabs.com/docs/v26.1/table-expressions.md)
- [Common Table Expressions (WITH Queries)](https://docs.cockroachlabs.com/docs/v26.1/common-table-expressions.md)
- [JSONPath Queries](https://docs.cockroachlabs.com/docs/v26.1/jsonpath.md)
- [Name Resolution](https://docs.cockroachlabs.com/docs/v26.1/sql-name-resolution.md)
- [NULL Handling](https://docs.cockroachlabs.com/docs/v26.1/null-handling.md)
- [Scalar Expressions](https://docs.cockroachlabs.com/docs/v26.1/scalar-expressions.md)
- [User-Defined Functions](https://docs.cockroachlabs.com/docs/v26.1/user-defined-functions.md)
- [Stored Procedures](https://docs.cockroachlabs.com/docs/v26.1/stored-procedures.md)
- [Triggers](https://docs.cockroachlabs.com/docs/v26.1/triggers.md)
- [Window Functions](https://docs.cockroachlabs.com/docs/v26.1/window-functions.md)
- [SQL Grammar](https://docs.cockroachlabs.com/docs/v26.1/sql-grammar.md)

#### Data Types

- [Data Types](https://docs.cockroachlabs.com/docs/v26.1/data-types.md)
- [ARRAY](https://docs.cockroachlabs.com/docs/v26.1/array.md)
- [BIT](https://docs.cockroachlabs.com/docs/v26.1/bit.md)
- [BOOL](https://docs.cockroachlabs.com/docs/v26.1/bool.md)
- [BYTES](https://docs.cockroachlabs.com/docs/v26.1/bytes.md)
- [CITEXT](https://docs.cockroachlabs.com/docs/v26.1/citext.md)
- [COLLATE](https://docs.cockroachlabs.com/docs/v26.1/collate.md)
- [DATE](https://docs.cockroachlabs.com/docs/v26.1/date.md)
- [DECIMAL](https://docs.cockroachlabs.com/docs/v26.1/decimal.md)
- [ENUM](https://docs.cockroachlabs.com/docs/v26.1/enum.md)
- [FLOAT](https://docs.cockroachlabs.com/docs/v26.1/float.md)
- [INET](https://docs.cockroachlabs.com/docs/v26.1/inet.md)
- [INT](https://docs.cockroachlabs.com/docs/v26.1/int.md)
- [INTERVAL](https://docs.cockroachlabs.com/docs/v26.1/interval.md)
- [JSONB](https://docs.cockroachlabs.com/docs/v26.1/jsonb.md)
- [LTREE](https://docs.cockroachlabs.com/docs/v26.1/ltree.md)
- [OID](https://docs.cockroachlabs.com/docs/v26.1/oid.md)
- [SERIAL](https://docs.cockroachlabs.com/docs/v26.1/serial.md)
- [STRING](https://docs.cockroachlabs.com/docs/v26.1/string.md)
- [TIME / TIMETZ](https://docs.cockroachlabs.com/docs/v26.1/time.md)
- [TIMESTAMP / TIMESTAMPTZ](https://docs.cockroachlabs.com/docs/v26.1/timestamp.md)
- [TSQUERY](https://docs.cockroachlabs.com/docs/v26.1/tsquery.md)
- [TSVECTOR](https://docs.cockroachlabs.com/docs/v26.1/tsvector.md)
- [UUID](https://docs.cockroachlabs.com/docs/v26.1/uuid.md)
- [VECTOR](https://docs.cockroachlabs.com/docs/v26.1/vector.md)

#### Spatial Data

- [Spatial Data Overview](https://docs.cockroachlabs.com/docs/v26.1/spatial-data-overview.md)
- [POINT](https://docs.cockroachlabs.com/docs/v26.1/point.md)
- [LINESTRING](https://docs.cockroachlabs.com/docs/v26.1/linestring.md)
- [POLYGON](https://docs.cockroachlabs.com/docs/v26.1/polygon.md)
- [MULTIPOINT](https://docs.cockroachlabs.com/docs/v26.1/multipoint.md)
- [MULTILINESTRING](https://docs.cockroachlabs.com/docs/v26.1/multilinestring.md)
- [MULTIPOLYGON](https://docs.cockroachlabs.com/docs/v26.1/multipolygon.md)
- [GEOMETRYCOLLECTION](https://docs.cockroachlabs.com/docs/v26.1/geometrycollection.md)
- [Well Known Text](https://docs.cockroachlabs.com/docs/v26.1/well-known-text.md)
- [Well Known Binary](https://docs.cockroachlabs.com/docs/v26.1/well-known-binary.md)
- [GeoJSON](https://docs.cockroachlabs.com/docs/v26.1/geojson.md)
- [SRID 4326 - longitude and latitude](https://docs.cockroachlabs.com/docs/v26.1/srid-4326.md)
- [ST_Contains](https://docs.cockroachlabs.com/docs/v26.1/st_contains.md)
- [ST_Within](https://docs.cockroachlabs.com/docs/v26.1/st_within.md)
- [ST_Intersects](https://docs.cockroachlabs.com/docs/v26.1/st_intersects.md)
- [ST_CoveredBy](https://docs.cockroachlabs.com/docs/v26.1/st_coveredby.md)
- [ST_Covers](https://docs.cockroachlabs.com/docs/v26.1/st_covers.md)
- [ST_Disjoint](https://docs.cockroachlabs.com/docs/v26.1/st_disjoint.md)
- [ST_Equals](https://docs.cockroachlabs.com/docs/v26.1/st_equals.md)
- [ST_Overlaps](https://docs.cockroachlabs.com/docs/v26.1/st_overlaps.md)
- [ST_Touches](https://docs.cockroachlabs.com/docs/v26.1/st_touches.md)
- [ST_ConvexHull](https://docs.cockroachlabs.com/docs/v26.1/st_convexhull.md)
- [ST_Union](https://docs.cockroachlabs.com/docs/v26.1/st_union.md)

#### Constraints

- [Constraints](https://docs.cockroachlabs.com/docs/v26.1/constraints.md)
- [CHECK Constraint](https://docs.cockroachlabs.com/docs/v26.1/check.md)
- [Default Value Constraint](https://docs.cockroachlabs.com/docs/v26.1/default-value.md)
- [Foreign Key Constraint](https://docs.cockroachlabs.com/docs/v26.1/foreign-key.md)
- [NOT NULL constraint](https://docs.cockroachlabs.com/docs/v26.1/not-null.md)
- [Primary Key Constraint](https://docs.cockroachlabs.com/docs/v26.1/primary-key.md)
- [Unique Constraint](https://docs.cockroachlabs.com/docs/v26.1/unique.md)

### Reference

- [Glossary](https://docs.cockroachlabs.com/docs/v26.1/architecture/glossary.md)
- [Cluster Settings](https://docs.cockroachlabs.com/docs/v26.1/cluster-settings.md)
- [Diagnostics Reporting](https://docs.cockroachlabs.com/docs/v26.1/diagnostics-reporting.md)

#### Architecture

- [Architecture Overview](https://docs.cockroachlabs.com/docs/v26.1/architecture/overview.md)
- [SQL Layer](https://docs.cockroachlabs.com/docs/v26.1/architecture/sql-layer.md)
- [Transaction Layer](https://docs.cockroachlabs.com/docs/v26.1/architecture/transaction-layer.md)
- [Distribution Layer](https://docs.cockroachlabs.com/docs/v26.1/architecture/distribution-layer.md)
- [Replication Layer](https://docs.cockroachlabs.com/docs/v26.1/architecture/replication-layer.md)
- [Storage Layer](https://docs.cockroachlabs.com/docs/v26.1/architecture/storage-layer.md)
- [Backup Architecture](https://docs.cockroachlabs.com/docs/v26.1/backup-architecture.md)

#### Cockroach Commands

- [cockroach Commands Overview](https://docs.cockroachlabs.com/docs/v26.1/cockroach-commands.md)
- [cockroach start](https://docs.cockroachlabs.com/docs/v26.1/cockroach-start.md)
- [cockroach init](https://docs.cockroachlabs.com/docs/v26.1/cockroach-init.md)
- [cockroach start-single-node](https://docs.cockroachlabs.com/docs/v26.1/cockroach-start-single-node.md)
- [cockroach cert](https://docs.cockroachlabs.com/docs/v26.1/cockroach-cert.md)
- [cockroach sql](https://docs.cockroachlabs.com/docs/v26.1/cockroach-sql.md)
- [cockroach sqlfmt](https://docs.cockroachlabs.com/docs/v26.1/cockroach-sqlfmt.md)
- [cockroach node](https://docs.cockroachlabs.com/docs/v26.1/cockroach-node.md)
- [cockroach nodelocal upload](https://docs.cockroachlabs.com/docs/v26.1/cockroach-nodelocal-upload.md)
- [cockroach auth-session](https://docs.cockroachlabs.com/docs/v26.1/cockroach-auth-session.md)
- [cockroach demo](https://docs.cockroachlabs.com/docs/v26.1/cockroach-demo.md)
- [cockroach debug ballast](https://docs.cockroachlabs.com/docs/v26.1/cockroach-debug-ballast.md)
- [cockroach debug encryption-active-key](https://docs.cockroachlabs.com/docs/v26.1/cockroach-debug-encryption-active-key.md)
- [cockroach debug encryption-decrypt](https://docs.cockroachlabs.com/docs/v26.1/cockroach-debug-encryption-decrypt.md)
- [cockroach debug job-trace](https://docs.cockroachlabs.com/docs/v26.1/cockroach-debug-job-trace.md)
- [cockroach debug list-files](https://docs.cockroachlabs.com/docs/v26.1/cockroach-debug-list-files.md)
- [cockroach debug merge-logs](https://docs.cockroachlabs.com/docs/v26.1/cockroach-debug-merge-logs.md)
- [cockroach debug pebble db analyze-data](https://docs.cockroachlabs.com/docs/v26.1/cockroach-debug-pebble-db-analyze-data.md)
- [cockroach debug tsdump](https://docs.cockroachlabs.com/docs/v26.1/cockroach-debug-tsdump.md)
- [cockroach debug zip](https://docs.cockroachlabs.com/docs/v26.1/cockroach-debug-zip.md)
- [cockroach statement-diag](https://docs.cockroachlabs.com/docs/v26.1/cockroach-statement-diag.md)
- [cockroach gen](https://docs.cockroachlabs.com/docs/v26.1/cockroach-gen.md)
- [cockroach userfile upload](https://docs.cockroachlabs.com/docs/v26.1/cockroach-userfile-upload.md)
- [cockroach userfile list](https://docs.cockroachlabs.com/docs/v26.1/cockroach-userfile-list.md)
- [cockroach userfile get](https://docs.cockroachlabs.com/docs/v26.1/cockroach-userfile-get.md)
- [cockroach userfile delete](https://docs.cockroachlabs.com/docs/v26.1/cockroach-userfile-delete.md)
- [cockroach version](https://docs.cockroachlabs.com/docs/v26.1/cockroach-version.md)
- [cockroach workload](https://docs.cockroachlabs.com/docs/v26.1/cockroach-workload.md)
- [cockroach-sql](https://docs.cockroachlabs.com/docs/v26.1/cockroach-sql-binary.md)

#### Logs

- [Logging Levels and Channels](https://docs.cockroachlabs.com/docs/v26.1/logging.md)
- [Log Formats](https://docs.cockroachlabs.com/docs/v26.1/log-formats.md)
- [Notable Event Types](https://docs.cockroachlabs.com/docs/v26.1/eventlog.md)

#### Metrics

- [Metrics](https://docs.cockroachlabs.com/docs/v26.1/metrics.md)
- [Multi-dimensional Metrics](https://docs.cockroachlabs.com/docs/v26.1/multi-dimensional-metrics.md)

#### Policies

- [API Support Policy](https://docs.cockroachlabs.com/docs/v26.1/api-support-policy.md)
- [Telemetry Collected by CockroachDB](https://docs.cockroachlabs.com/docs/v26.1/telemetry.md)

#### Third-Party Support

- [Third-Party Tools Supported by Cockroach Labs](https://docs.cockroachlabs.com/docs/v26.1/third-party-database-tools.md)
- [Third-Party Monitoring Integrations](https://docs.cockroachlabs.com/docs/v26.1/third-party-monitoring-tools.md)
- [Third-Party Tools Supported by the Community](https://docs.cockroachlabs.com/docs/v26.1/community-tooling.md)

#### Security

- [CockroachDB Security Overview](https://docs.cockroachlabs.com/docs/v26.1/security-reference/security-overview.md)
- [Authorization in CockroachDB](https://docs.cockroachlabs.com/docs/v26.1/security-reference/authorization.md)
- [Encryption in CockroachDB](https://docs.cockroachlabs.com/docs/v26.1/security-reference/encryption.md)
- [Column Level Encryption](https://docs.cockroachlabs.com/docs/v26.1/column-level-encryption.md)
- [Row-Level Security (RLS) Overview](https://docs.cockroachlabs.com/docs/v26.1/row-level-security.md)
- [Transport Layer Security (TLS) and Public Key Infrastructure (PKI)](https://docs.cockroachlabs.com/docs/v26.1/security-reference/transport-layer-security.md)

##### Authentication

- [SQL Authentication](https://docs.cockroachlabs.com/docs/v26.1/security-reference/authentication.md)
- [SASL/SCRAM-SHA-256 Secure Password-based Authentication](https://docs.cockroachlabs.com/docs/v26.1/security-reference/scram-authentication.md)

#### System Catalogs

- [System Catalogs](https://docs.cockroachlabs.com/docs/v26.1/system-catalogs.md)
- [crdb_internal](https://docs.cockroachlabs.com/docs/v26.1/crdb-internal.md)
- [information_schema](https://docs.cockroachlabs.com/docs/v26.1/information-schema.md)
- [pg_catalog](https://docs.cockroachlabs.com/docs/v26.1/pg-catalog.md)
- [pg_extension](https://docs.cockroachlabs.com/docs/v26.1/pg-extension.md)

#### FAQs

- [CockroachDB FAQs](https://docs.cockroachlabs.com/docs/v26.1/frequently-asked-questions.md)
- [Operational FAQs](https://docs.cockroachlabs.com/docs/v26.1/operational-faqs.md)
- [Licensing FAQs](https://docs.cockroachlabs.com/docs/v26.1/licensing-faqs.md)

### Cluster API

#### Overview

- [CockroachDB Cluster API (2.0)](https://docs.cockroachlabs.com/docs/api/cluster/index.md)

#### Endpoints

##### API Reference

- [List databases](https://docs.cockroachlabs.com/docs/api/cluster/v2/list-databases.md): List all databases on this cluster.
- [Get database descriptor ID](https://docs.cockroachlabs.com/docs/api/cluster/v2/get-database-descriptor-id.md): Retrieve the database's descriptor ID.
- [List grants on a database](https://docs.cockroachlabs.com/docs/api/cluster/v2/list-grants-on-a-database.md): Retrieve grants on a database. Grants are the privileges granted to users on this database.
- [List tables on a database](https://docs.cockroachlabs.com/docs/api/cluster/v2/list-tables-on-a-database.md): List names of all tables in the database. The names of all responses will be schema-qualified.
- [Get table details](https://docs.cockroachlabs.com/docs/api/cluster/v2/get-table-details.md): Retrieve details about a table.
- [List events](https://docs.cockroachlabs.com/docs/api/cluster/v2/list-events.md): List the latest event log entries, in descending order.
- [Check node health](https://docs.cockroachlabs.com/docs/api/cluster/v2/check-node-health.md): Check for node health. If `ready` is true, also check if this node is fully operational and ready to accept SQL connections. Otherwise, this endpoint always returns a successful response (if the API server is up).
- [Log in](https://docs.cockroachlabs.com/docs/api/cluster/v2/log-in.md): Create an API session for use with API endpoints that require authentication.
- [Log out](https://docs.cockroachlabs.com/docs/api/cluster/v2/log-out.md): Log out, invalidating the API session token.
- [List nodes](https://docs.cockroachlabs.com/docs/api/cluster/v2/list-nodes.md): List all nodes on this cluster.
- [List node ranges](https://docs.cockroachlabs.com/docs/api/cluster/v2/list-node-ranges.md): List information about ranges on a specified node. If a list of range IDs is specified, only information about those ranges is returned.
- [List hot ranges](https://docs.cockroachlabs.com/docs/api/cluster/v2/list-hot-ranges.md): List information about hot ranges. If a list of range IDs is specified, only information about those ranges is returned.
- [Get range details](https://docs.cockroachlabs.com/docs/api/cluster/v2/get-range-details.md): Retrieve more information about a specific range.
- [List sessions](https://docs.cockroachlabs.com/docs/api/cluster/v2/list-sessions.md): List all sessions on this cluster. If a username is provided, only sessions from that user are returned.
- [List users](https://docs.cockroachlabs.com/docs/api/cluster/v2/list-users.md): List SQL users on this cluster.

### Troubleshoot

#### Troubleshooting

- [Troubleshooting Overview](https://docs.cockroachlabs.com/docs/v26.1/troubleshooting-overview.md)
- [Common Errors and Solutions](https://docs.cockroachlabs.com/docs/v26.1/common-errors.md)
- [Troubleshoot Self-Hosted Setup](https://docs.cockroachlabs.com/docs/v26.1/cluster-setup-troubleshooting.md)
- [Troubleshoot SQL Statements](https://docs.cockroachlabs.com/docs/v26.1/query-behavior-troubleshooting.md)
- [Transaction Retry Error Reference](https://docs.cockroachlabs.com/docs/v26.1/transaction-retry-error-reference.md)
- [Transaction Retry Error Example](https://docs.cockroachlabs.com/docs/v26.1/transaction-retry-error-example.md)
- [Differences in Metrics between Third-Party Monitoring Integrations and DB Console](https://docs.cockroachlabs.com/docs/v26.1/differences-in-metrics-between-third-party-monitoring-integrations-and-db-console.md)
- [Understand Hotspots](https://docs.cockroachlabs.com/docs/v26.1/understand-hotspots.md)
- [Detect Hotspots](https://docs.cockroachlabs.com/docs/v26.1/detect-hotspots.md)
- [Troubleshoot Query Plan Regressions](https://docs.cockroachlabs.com/docs/v26.1/troubleshoot-query-plan-regressions.md)
- [Troubleshoot Replication Zones](https://docs.cockroachlabs.com/docs/v26.1/troubleshoot-replication-zones.md)
- [Support Resources](https://docs.cockroachlabs.com/docs/v26.1/support-resources.md)
- [Automatic CPU Profiler](https://docs.cockroachlabs.com/docs/v26.1/automatic-cpu-profiler.md)
- [Automatic Go Execution Tracer](https://docs.cockroachlabs.com/docs/v26.1/automatic-go-execution-tracer.md)
- [Transaction Diagnostics](https://docs.cockroachlabs.com/docs/v26.1/transaction-diagnostics.md)

## OpenAPI Specs

- [cluster-api-v2](/openapi/cluster-api-v2.json)