/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 vote165 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote100 views1 answer
Print sum of values sql
SQL
0 vote146 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote128 views1 answer
Create date sql
SQL
0 vote104 views1 answer
Como leer datos de mysql esp32
SQL
0 vote145 views2 answers
Oracle chain rules
SQL
22 votes177 views1 answer
Mysql workbench
SQL
11 votes132 views2 answers
Insert date sql
SQL
1 vote139 views1 answer
Oracle rolling back transactions
SQL
3 votes149 views1 answer
Sql cast to integer
SQL