/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 vote223 views1 answer
Import mysql'
SQL
6 votes230 views1 answer
Oracle desc table primary key
SQL
2 votes235 views2 answers
Checking data type in sql server
SQL
-1 vote268 views2 answers
Sql search all tables for attributes
SQL
0 vote251 views2 answers
How to take recent row without limit in mysql
SQL
1 vote263 views1 answer
Opensuse restart MySQL
SQL
-2 votes250 views1 answer
Trunc in sql
SQL
14 votes238 views1 answer
Oracle new column
SQL
0 vote223 views6 answers
Unique key in sql
SQL
6 votes240 views1 answer
Oracle rank
SQL