/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

4 votes309 views1 answer
How to drop a database in sql server when it is in use
SQL
9 votes293 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote262 views1 answer
Pl/sql loop example
SQL
0 vote288 views3 answers
Fetlife
SQL
4 votes270 views1 answer
Sql delete where in select
SQL
13 votes271 views6 answers
Current date sql
SQL
1 vote275 views1 answer
Alphabetical order mysql
SQL
0 vote274 views1 answer
Match end of string regex sql
SQL
10 votes292 views4 answers
Else if mysql
SQL
0 vote293 views1 answer
Display all node label neo4j
SQL