using default constraints

Question

CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
City varchar(255) DEFAULT 'Sandnes'
);

Answer 1

ID int PRIMARY KEY IDENTITY(1,1)

The keyword PRIMARY KEY set NOT NULL for default and It will be an ID unique. The keyword IDENTITY increment your ID in 1