In Cassandra, CREATE TABLE command is used to create a table. Here, column family is used to store data just like table in RDBMS.
So, you can say that CREATE TABLE command is used to create a column family in Cassandra.
CREATE (TABLE | COLUMNFAMILY) <tablename> ('<column-definition>' , '<column-definition>') (WITH <option> AND <option>)
For declaring a primary key:
CREATE TABLE tablename( column1 name datatype PRIMARYKEY, column2 name data type, column3 name data type. )
You can also define a primary key by using the following syntax:
Create table TableName
) with PropertyName=PropertyValue;
There are two types of primary keys:
- Single primary key: Use the following syntax for single primary key.
Primary key (ColumnName)
- Compound primary key: Use the following syntax for single primary key.
Primary key(ColumnName1,ColumnName2 . . .)
Let’s take an example to demonstrate the CREATE TABLE command.
Here, we are using already created Keyspace “javatpoint”.
CREATE TABLE student( student_id int PRIMARY KEY, student_name text, student_city text, student_fees varint, student_phone varint );
The table is created now. You can check it by using the following command.
SELECT * FROM student;