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

1 vote289 views1 answer
Mysql add fields
SQL
0 vote310 views1 answer
How to get table id sequence postgres
SQL
1 vote263 views1 answer
Nested if in mysql
SQL
0 vote277 views1 answer
Get first 3 letter of department name in sql
SQL
1 vote289 views1 answer
Delete from inner join sql
SQL
2 votes267 views1 answer
Enum in SQL Server
SQL
1 vote299 views2 answers
Maximum number of tables in mysql
SQL
0 vote267 views1 answer
Rabbitmq service not starting
SQL
8 votes268 views1 answer
Oracle add month
SQL
2 votes266 views1 answer
Oracle cpu per session
SQL