menu_open
home
Docs Home
Astra
expand_more
Astra DB Serverless
Astra Streaming
Astra CLI
Langflow
expand_more
Langflow Open Source
open_in_new
Langflow in the Cloud
HCD
expand_more
HCD 1.2
HCD 1.1
DSE
expand_more
DSE 6.9
DSE 6.8
DSE 5.1
DSE capacity planning guide
OpsCenter 6.8
Third-party software
Supported platforms
Product compatibility
Open Source
expand_more
Apache Cassandra
open_in_new
Apache Cassandra capacity planning guide
DataStax Apache Pulsar Connector
CDC for Apache Cassandra
K8ssandra
open_in_new
Kubernetes Autoscaling for Apache Pulsar
Kubernetes Operator for Apache Cassandra
Stargate
open_in_new
Starlight for JMS
Starlight for Kafka
Starlight for Rabbit MQ
Luna Support Services
expand_more
Luna for Apache Cassandra
Luna Streaming
Luna for Langflow
open_in_new
Tools
expand_more
Mission Control
Migration
Drivers
DataStax Studio
CQL
Was this helpful?
thumb_up
Yes
thumb_down
No
Thank you for your feedback.
Give Feedback
ESC
close
How can we improve the documentation?
Cancel
Submit Feedback
CQL for Apache Cassandra
Cassandra 5.0
expand_more
HCD (Latest)
DSE 6.9
DSE 6.8
DSE 5.1
Cassandra 5.0
Astra DB
Get started
expand_more
Key concepts
expand_more
Apache Cassandra structure
Partitions and keys
Replication and consistency
CQL quickstart
Vector search quickstart
SAI quickstart
Data modeling
expand_more
Data modeling methodology
Data modeling best practices
Connect
expand_more
Access data using CQL
Start cqlsh
Develop
expand_more
Keyspaces
expand_more
Keyspace concepts
Create a keyspace
Check a keyspace
Alter a keyspace
Drop a keyspace
Tables
expand_more
Table concepts
Create a table
Check a table
Alter a table
Truncate a table
Drop a table
Columns
expand_more
Create a table column
Check column existence
Alter columns
Collections
User-defined objects
expand_more
UDTs
expand_more
User-defined types (UDTs)
Create a UDT
Get a UDT
Alter a UDT
Drop a UDT
Insert or update UDT data
UDFs
expand_more
Create a user-defined function (UDF)
Check a user-defined function (UDF)
Drop a user-defined function (UDF)
UDAs
expand_more
Create a user-defined aggregate function (UDA)
Checking a user-defined aggregate (UDA)
Drop a user-defined aggregate (UDA)
Materialized Views
expand_more
Prepare to use materialized views
Materialized views (MVs) examples
Create a materialized view (MV)
Alter a materialized view (MV)
Drop a materialized view
Indexes
expand_more
Index types and use cases
SAI
expand_more
SAI performance and use cases
Create SAI index
Check SAI existence
Alter SAI index
Drop SAI index
Query with SAI
SAI examples
Configure SAI indexes
Monitor SAI indexes
SAI FAQ
2i
expand_more
Create and use 2i indexes
2i examples
SASI
Insert
expand_more
Insert and update data
Use lightweight transactions (LWTs)
Insert JSON formatted values
Set the time-to-live (TTL)
Batch operations
Delete
expand_more
Delete a value or entire row
Expiring data with time-to-live
Query
expand_more
Querying
Use tracing
Secure
expand_more
Secure
Security quickstart
Configure authentication and authorization
Reference
expand_more
Reference
CQL command syntax
Arithmetic operators
CQL native functions
CQL native aggregates
Data types
expand_more
CQL data types
Date, time, and timestamp format
UUID and timeuuid
System and virtual tables
expand_more
Keyspace tables
Keyspace, table, and column information
Querying system tables
Functions, aggregates, and user types
Virtual keyspaces and tables
Virtual tables for SAI indexes and SSTables
System tables for authentication and authorization
cqlsh
expand_more
cqlsh startup options
Configuring a cqlshrc file
CQL shell (cqlsh) reference
CAPTURE
CLEAR
CONSISTENCY
COPY TO
COPY FROM
DESCRIBE AGGREGATE
DESCRIBE CLUSTER
DESCRIBE SCHEMA
DESCRIBE FUNCTION
DESCRIBE INDEX
DESCRIBE KEYSPACE
DESCRIBE MATERIALIZED VIEW
DESCRIBE SEARCH INDEX
DESCRIBE TABLE
DESCRIBE TYPE
EXECUTE AS
EXPAND
EXIT
LOGIN
PAGING
SERIAL CONSISTENCY
SHOW
SOURCE
TIMING
TRACING
CQL commands
expand_more
CQL quick reference
ALTER KEYSPACE
ALTER MATERIALIZED VIEW
ALTER ROLE
ALTER SEARCH INDEX CONFIG
ALTER SEARCH INDEX SCHEMA
ALTER TABLE
ALTER TYPE
ALTER USER (Deprecated)
BATCH
COMMIT SEARCH INDEX
CREATE AGGREGATE
CREATE FUNCTION
CREATE INDEX
CREATE KEYSPACE
CREATE MATERIALIZED VIEW
CREATE ROLE
CREATE SEARCH INDEX
CREATE TABLE
CREATE TYPE
CREATE USER (Deprecated)
DELETE
DROP AGGREGATE
DROP FUNCTION
DROP INDEX
DROP KEYSPACE
DROP MATERIALIZED VIEW
DROP ROLE
DROP SEARCH INDEX
DROP TABLE
DROP TYPE
DROP USER (Deprecated)
GRANT ROLE
GRANT PERMISSION
INSERT
LIST PERMISSIONS
LIST ROLES
LIST USERS (Deprecated)
RESTRICT
REVOKE ROLE
REVOKE PERMISSION
SELECT
TRUNCATE
UNRESTRICT
UPDATE
USE
home
DataStax Home
menu_book
Glossary
support
Support
downloading
Downloads
