SQL create statement incorrect syntax near auto increment

Question

I created the following table, but I get an error;

Incorrect syntax near 'AUTO_INCREMENT'.

SQL

CREATE TABLE [dbo].[MY_TABLE] (
    [ID] INT NOT NULL AUTO_INCREMENT,
    [NAME]          NVARCHAR (100) NULL,
    [SCHOOL]             NVARCHAR (100) NULL,
    PRIMARY KEY (ID)
);

i think i have done everything right. can someone help me out?

Answer 1

It is IDENTITY not AUTO_INCREMENT in SQL Server.

Try this instead:

CREATE TABLE [dbo].[MY_TABLE] (
    [ID] INT NOT NULL IDENTITY(1, 1),
    [NAME]          NVARCHAR (100) NULL,
    [SCHOOL]             NVARCHAR (100) NULL,
    PRIMARY KEY (ID)
);

Answer 2

Its not AUTO_INCREMENT. Here the Demo from sqlfiddle