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

6 votes394 views3 answers
Mysql remove user privileges
SQL
0 vote343 views1 answer
How to change mysql port in xampp
SQL
1 vote344 views2 answers
Pl sql case
SQL
0 vote358 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote397 views1 answer
Postgresql print sessions using the database
SQL
1 vote339 views1 answer
Primary key reset in SQL database
SQL
7 votes367 views2 answers
Execute mysql file
SQL
7 votes381 views3 answers
Python and mysql connectivity
SQL
17 votes353 views6 answers
Sql current date
SQL
0 vote362 views1 answer
Oracle list subpartitions
SQL