Commands

This section describes the Cassandra Query Language (CQL) commands supported by the DataStax Enterprise database.


ALTER TABLE

Modifies the columns and properties of a table, or modify

ALTER TYPE

Modifies an existing user-defined type (UDT).

ALTER USER (Deprecated)

Deprecated. Alter existing user options.

BATCH

Applies multiple data modification language (DML) statements with atomicity and/or in isolation.

CREATE CUSTOM INDEX

Creates a storage-attached index.

CREATE INDEX

Defines a new index for a single column of a table.

CREATE TABLE

Creates a new table.

CREATE TYPE

Creates a custom data type in the keyspace that contains one or more fields of related information.

CREATE USER (Deprecated)

Deprecated. Creates a new user.

DELETE

Removes data from one or more columns or removes the entire row

DROP INDEX

Removes an index from a table.

DROP TABLE

Removes the table.

DROP TYPE

Drop a user-defined type.

DROP USER (Deprecated)

Removes a user.

GRANT

Allow access to database resources.

INSERT

Inserts an entire row or upserts data into existing rows.

RESTRICT

Denies the permission on a resource, even if the role is directly granted or inherits permissions.

RESTRICT ROWS

Configures the column used for row-level access control.

REVOKE

Removes privileges on database objects from roles.

SELECT

Returns data from a table.

TRUNCATE

Removes all data from a table.

UNRESTRICT

Removes a restriction from a role.

UNRESTRICT ROWS

Removes the column definition for row-level access control.

UPDATE

Modifies one or more column values to a row in a table.

USE

Selects the keyspace for the current client session.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com