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 votes267 views3 answers
Mysql list tables by size
SQL
0 vote287 views1 answer
ORA-13717
SQL
0 vote265 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
2 votes274 views2 answers
Mysql show table column comments sql
SQL
10 votes258 views4 answers
Primary key sql
SQL
0 vote279 views1 answer
Set engine to innodb
SQL
0 vote275 views1 answer
Sql mod even odd
SQL
0 vote281 views1 answer
Get sum sqlite android
SQL
5 votes251 views2 answers
Mysql where in array
SQL
2 votes279 views1 answer
Update with join sql server
SQL