/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

1 vote266 views1 answer
Select not matching data from two tables
SQL
5 votes285 views1 answer
Oracle nls parameters
SQL
3 votes588 views1 answer
Postgresql cast
SQL
0 vote268 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote282 views1 answer
Update database collation in postgresql
SQL
2 votes332 views1 answer
Sql find not in list
SQL
11 votes279 views1 answer
Ddl materialized view
SQL
1 vote286 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote277 views1 answer
Optimize sql query
SQL
0 vote329 views2 answers
Clauses in mysql
SQL