Sql auto_increment syntax

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

Source: stackoverflow.com

Similar codes

2 votes215 views1 answer
Sql string starts with
SQL
0 vote234 views1 answer
Radius search with point data in mysql
SQL
1 vote185 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote166 views1 answer
Mysql search multiple tables
SQL
24 votes179 views4 answers
Postgres delete database
SQL
-1 vote179 views1 answer
How to change the auto increment in existing table mysql
SQL
2 votes181 views4 answers
Sql query interview questions
SQL
1 vote164 views1 answer
Substr sql last character
SQL
0 vote183 views1 answer
Mysql get last 2 month data
SQL
0 vote167 views1 answer
Stuff in sql server
SQL