How do I define a unique constraint that is not the primary key (aka alternate keys)? Converting from MariaDB…
id BIGINT PRIMARY KEY,
logonId VARCHAR(100) NOT NULL,
UNIQUE IX_Users_LogonId (logonId),
UNIQUE IX_Users_Name (lastName, firstName, middleName)
In this use case, I have a primary key that is generated. Their logonId and name must be unique.