/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 vote258 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
1 vote228 views2 answers
Mysql trim spaces
SQL
0 vote231 views1 answer
Postgresql check total storage
SQL
0 vote214 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
1 vote247 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote233 views1 answer
Mysql update table from select on another table
SQL
0 vote230 views1 answer
Sql add calculated column
SQL
6 votes217 views1 answer
What is where clause in sql
SQL
2 votes206 views1 answer
Oracle sql drop column if exists
SQL
0 vote215 views1 answer
Mysql autoincrement valor inicial
SQL