Create Table with Autoincrement

How Can We Help?

Created OnApril 10, 2017

byMichael Dyhr Iversen

The important part is the IDENTITY(x,x) and PRIMARY KEY.

CREATE TABLE Persons (
    ID int IDENTITY(1,1) PRIMARY KEY,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);