/SQL/Sql create tabel with primary key auto_increment code

Sql create tabel with primary key auto_increment code

Create table with primary key auto increment in sql

CREATE TABLE table_name (
    id INT NOT NULL IDENTITY(1, 1),
    name NVARCHAR (100) NULL,
    school NVARCHAR (100) NULL,
    PRIMARY KEY (ID)
);

Sql create tabel with primary key auto_increment code

CREATE TABLE books (
  id              INT           NOT NULL    IDENTITY    PRIMARY KEY,
  title           VARCHAR(100)  NOT NULL,
  primary_author  VARCHAR(100),
);

Source: chartio.com

Similar codes

1 vote377 views1 answer
Sql server list locks
SQL
2 votes334 views1 answer
Convert series number to date in sql
SQL
0 vote401 views1 answer
MySQL - Enabling the Event Scheduler
SQL
1 vote365 views2 answers
How to add amount between date in sql
SQL
0 vote368 views1 answer
Postgresql in vs any performance
SQL
0 vote390 views1 answer
Min mysql
SQL
0 vote357 views1 answer
Grepper sql workbench download
SQL
1 vote356 views3 answers
Postgresql crete view
SQL
7 votes357 views6 answers
Nth highest salary in sql
SQL
1 vote367 views1 answer
Mysql select all and rename one
SQL