Commands
This section describes the Cassandra Query Language (CQL) commands supported by the DataStax Enterprise database.
- ALTER KEYSPACE
-
Changes keyspace replication strategy and enables or disables commit log.
- ALTER MATERIALIZED VIEW
-
Changes the table properties of a materialized view.
- ALTER ROLE
-
Changes password and sets superuser or login options.
- ALTER SEARCH INDEX CONFIG
-
Changes a search index for DSE Search configuration.
- ALTER SEARCH INDEX SCHEMA
-
Changes a search schema for DSE Search.
- 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.
- COMMIT SEARCH INDEX
-
Updates the search index with the most recent data after an INSERT, UPDATE, or DELETE.
- CREATE AGGREGATE
-
Defines a user-defined aggregate.
- CREATE FUNCTION
-
Creates custom function to execute user provided code.
- CREATE INDEX
-
Defines a new index for a single column of a table.
- CREATE KEYSPACE
-
Defines a new keyspace.
- CREATE MATERIALIZED VIEW
-
Optimizes read requests and eliminates the need for multiple write requests by duplicating data from a base table.
- CREATE ROLE
-
Creates a cluster wide database object used for access control.
- CREATE SEARCH INDEX
-
Defines a new search index for an existing 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 AGGREGATE
-
Deletes a user-defined aggregate from a keyspace.
- DROP FUNCTION
-
Deletes a user-defined function (UDF) from a keyspace.
- DROP INDEX
-
Removes an index from a table.
- DROP KEYSPACE
-
Removes the keyspace.
- DROP MATERIALIZED VIEW
-
Removes the named materialized view.
- DROP ROLE
-
Removes a role.
- DROP SEARCH INDEX
-
Drops a table search index.
- 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.
- LIST PERMISSIONS
-
Lists permissions on resources.
- LIST ROLES
-
Lists roles and shows superuser and login status.
- LIST USERS (Deprecated)
-
Lists existing internal authentication users and their superuser status.
- REBUILD SEARCH INDEX
-
Rebuilds a search index for DSE Search.
- RELOAD SEARCH INDEX
-
Replaces the active search index schema and configuration with pending schema and configuration.
- 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.
