/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 vote299 views1 answer
Separator mysql
SQL
0 vote341 views1 answer
Postgresql print sessions using the database
SQL
0 vote311 views2 answers
Reseed sql identity
SQL
1 vote293 views1 answer
Nested if in mysql
SQL
0 vote306 views1 answer
Connexion mysql
SQL
0 vote325 views2 answers
Dbms transaction tutorialspoint
SQL
1 vote344 views2 answers
Oracle leftmost characters
SQL
0 vote288 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote318 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote316 views1 answer
Deleting database in sql
SQL