/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

36 votes193 views6 answers
Rename table sql
SQL
2 votes180 views1 answer
Set boolean flasksql
SQL
0 vote167 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote167 views1 answer
Sql remove last x char
SQL
-1 vote212 views2 answers
Sql truncate number
SQL
0 vote195 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote171 views1 answer
Mql5 datetime get hour
SQL
1 vote187 views2 answers
How to add amount between date in sql
SQL
2 votes239 views3 answers
Sql delete duplicate
SQL
1 vote189 views1 answer
Postgresql delete cascade
SQL