1CREATE TABLE Persons (
2 Personid int NOT NULL AUTO_INCREMENT,
3 LastName varchar(255) NOT NULL,
4 FirstName varchar(255),
5 Age int,
6 PRIMARY KEY (Personid)
7);
8INSERT INTO Persons (FirstName,LastName)
9VALUES ('Lars','Monsen');
1CREATE TABLE table_name (
2 id INT NOT NULL IDENTITY(1, 1),
3 name NVARCHAR (100) NULL,
4 school NVARCHAR (100) NULL,
5 PRIMARY KEY (ID)
6);