There are two ways:
1. CREATE UNIQUE INDEX <index_name> ON <table_name>(column_name);
2. just in the create table SQL sentence:
CREATE TABLE <table_name>(
user_id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
unique_column VARCHAR(20) NOT NULL,
......
UNIQUE (unique_column)
);
1. CREATE UNIQUE INDEX <index_name> ON <table_name>(column_name);
2. just in the create table SQL sentence:
CREATE TABLE <table_name>(
user_id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
unique_column VARCHAR(20) NOT NULL,
......
UNIQUE (unique_column)
);