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 votes202 views4 answers
Check timezone of mysql database
SQL
2 votes238 views1 answer
Sql count having
SQL
0 vote230 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
1 vote236 views2 answers
How to add amount between date in sql
SQL
4 votes216 views2 answers
Sql offset
SQL
1 vote354 views1 answer
Mysql data from file
SQL
0 vote194 views1 answer
Oracle list proxy users
SQL
1 vote207 views1 answer
Oracle duration between timestamps
SQL
0 vote314 views1 answer
Oracle db get table sizes
SQL
1 vote217 views1 answer
Postgres regex remove special characters
SQL