Using a simple primary key
Use a simple primary key to create a single column that you can use to query and return results.
This example creates a
cyclist_name table storing an ID number and a cyclist’s first and last names in columns.
The table uses a UUID as a Primary_key.
This table can be queried to discover the name of a cyclist given their ID number.
A simple primary key table can be created in multiple ways, as shown in the following examples.
Create the table
idthe primary key. Insert the
PRIMARY KEYkeywords after the column name in the
CREATE TABLEdefinition. Before creating the table, set the keyspace with a
CREATE TABLE cyclist_name ( id UUID PRIMARY KEY, lastname text, firstname text );
*.This same example can be written with the primary key identified at the end of the table definition.
PRIMARY KEY keywords after the last column definition in the
CREATE TABLE definition, followed by the column name of the key.
The column name of the primary key is enclosed in parentheses, which is
id in the example below.
CREATE TABLE cycling.cyclist_name (
PRIMARY KEY (id)
The keyspace name can be used to identify the keyspace in the
CREATE TABLEstatement instead of the
CREATE TABLE cycling.cyclist_name ( id UUID PRIMARY KEY, lastname text, firstname text );