/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

0 vote143 views1 answer
Sql select duplicates based on two columns
SQL
0 vote142 views1 answer
What is initial catalog in sql connection string
SQL
0 vote179 views1 answer
Mysql get hour from datetime
SQL
0 vote144 views1 answer
RowDataPacket
SQL
2 votes166 views2 answers
Mysql add hours to time field
SQL
7 votes139 views3 answers
How ot change name of column mysql
SQL
0 vote150 views1 answer
Combine 2 columns search query mysql
SQL
1 vote145 views1 answer
Postgres first_value in gropby
SQL
0 vote138 views1 answer
Sqldf change user
SQL
2 votes150 views2 answers
Mysql bidirectional composite primary key
SQL