/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 vote212 views2 answers
Sql if empty then
SQL
1 vote207 views1 answer
Can not connect to mysql server
SQL
0 vote236 views1 answer
Get current date data in mysql
SQL
0 vote221 views1 answer
Postgresql using reserved word as column name
SQL
0 vote234 views1 answer
Tsql delete all rows
SQL
1 vote223 views1 answer
Sqlite update from another table
SQL
0 vote221 views1 answer
Jenkins SQLCMD run
SQL
13 votes228 views3 answers
Insert mysql ifile nto database
SQL
0 vote204 views2 answers
Cascade syntax in sql
SQL
0 vote213 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL