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 Astra DB
Astra DB
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
Check 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
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
SAI FAQ
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 CLUSTER
DESCRIBE SCHEMA
DESCRIBE INDEX
DESCRIBE KEYSPACE
DESCRIBE TABLE
DESCRIBE TYPE
EXPAND
EXIT
PAGING
SERIAL CONSISTENCY
SHOW
SOURCE
TIMING
TRACING
CQL commands
expand_more
CQL quick reference
ALTER TABLE
ALTER TYPE
BATCH
CREATE INDEX
CREATE TABLE
CREATE TYPE
DELETE
DROP INDEX
DROP TABLE
DROP TYPE
INSERT
SELECT
TRUNCATE
UPDATE
USE
home
DataStax Home
menu_book
Glossary
support
Support
downloading
Downloads
