Answer: Yes, we can define multiple unique keys in a table.
Create Table Sampletable
(
UserID integer NOT NULL PRIMARY KEY,
UserName varchar(50),
FirstName varchar(50) ,
LastName varchar(50),
CONSTRAINT us_UserId UNIQUE (UserID),
CONSTRAINT us_Username UNIQUE (UserName)
)
|
Alert Moderator