/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 vote178 views1 answer
Sql sum if
SQL
15 votes186 views2 answers
How to know the username of postgresql
SQL
0 vote220 views1 answer
Update database collation in postgresql
SQL
0 vote182 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote181 views2 answers
Psql commande \gset
SQL
0 vote167 views1 answer
Deny select insert update delete sql
SQL
0 vote186 views1 answer
Criteria builder select subset of column
SQL
1 vote194 views1 answer
Sql select whole row max column
SQL
1 vote189 views2 answers
Sql insert timestamp
SQL
7 votes210 views3 answers
Restore postgres database from sql file
SQL