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 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 ROLE: Allow one role to inherit the permissions of another role.
GRANT PERMISSION: 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 ROLE: Removes roles from roles.
REVOKE PERMISSION: 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.

Give Feedback