Developing database resources
|
Schema changes, which involve CREATE, ALTER, and DROP statements, are not safe for concurrent use. Performing more than one change in flight has a high probability of causing irreconcilable conflicts, with nodes in the cluster using different schema “versions” indefinitely. |
- Keyspaces
-
Keyspace concepts for managing data availability, and keyspace data manipulation language(DML)/data definition language(DDL): create, check, modify, and drop keyspaces.
- Data types
-
Data types available for table schema.
- Tables
-
Table concepts for managing schema for storing data, and table DML/DDL: create, check, modify, truncate, and drop tables.
- Columns
-
Column concepts for managing schema for storing data, and column DML/DDL: create, check, modify, and drop columns.
- Materialized views
-
Create, replace, and drop customized user-defined functions, aggregates, and types.
- User-defined types (UDTs)
-
Create, replace, and drop customized user-defined types.
- User-defined functions and aggregates
-
Create, replace, alter, and drop customized user-defined functions and aggregates.
- [Indexing]
-
Create, check, alter, and drop Storage-attached indexing (SAI), Secondary indexing (2i), and DSE Search indexing