Cassandra Query Language (CQL) - CREATE TABLE
This is some syntax to work with Cassandra. CREATE TABLE Required parameters: table_name: name of the table to index column_name: name of the column column_definition Restriction: A table must have at least one PRIMARY KEY When PRIMARY KEY is at the end of a column definition, that column is the only primary key for the table, and is defined as the partition key (*) A static column cannot be a primary key (**) Primary keys can include frozen collections So, let's explain (*): When you create a table in SQL (especially in Cassandra or similar NoSQL databases), you can define a primary key in two ways: After the column , like this: CREATE TABLE users ( id UUID PRIMARY KEY, name text, email text ); Or at the end , like this: CREATE TABLE users ( id UUID, name text, email text, PRIMARY KEY ...
