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

0 vote164 views1 answer
Find how many tables in database sql query
SQL
0 vote149 views1 answer
If column value is null then in mysql
SQL
1 vote176 views1 answer
Is sql fast
SQL
0 vote138 views1 answer
How to find username and password in oracle 18c
SQL
2 votes129 views1 answer
Oracle create directory
SQL
16 votes159 views2 answers
Sql vs nosql
SQL
0 vote133 views1 answer
Create new table pl sql
SQL
0 vote208 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote184 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
2 votes146 views4 answers
Mysql select into new table
SQL