In Apache AGE, what is the process to define a Primary Key?

edit

In Apache AGE, the process to define a Primary Key is as follows:

1. Create a table using the CREATE TABLE statement, providing the column names, data types, and any constraints.
2. Specify the column(s) that will serve as the primary key using the PRIMARY KEY constraint.
3. The primary key can be defined as a single column or a combination of multiple columns.
4. If the primary key is not defined during the table creation, it can be added later using an ALTER TABLE statement.

For example, the following SQL statement creates a table with a primary key on the "id" column:

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50)
);

Alternatively, a primary key constraint can be added to an existing table using the ALTER TABLE statement:

ALTER TABLE users
ADD CONSTRAINT pk_users_id PRIMARY KEY (id);