/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 vote193 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote202 views1 answer
Restore backupfile discourse
SQL
6 votes219 views3 answers
Mysql remove user privileges
SQL
2 votes225 views3 answers
Sql interview query questions
SQL
3 votes212 views2 answers
Mysql user permission database
SQL
0 vote202 views1 answer
Oracle show grants on table
SQL
0 vote201 views1 answer
MySql count occurences more than"
SQL
0 vote186 views1 answer
Sql right characters
SQL
25 votes215 views3 answers
How to use a database to see tables mysql
SQL
0 vote204 views1 answer
Replace null value within column mysql
SQL