/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

14 votes216 views1 answer
How to export db from mysql
SQL
0 vote166 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
-1 vote149 views1 answer
Adding a new table psql
SQL
12 votes169 views6 answers
Distinct in sql server
SQL
0 vote144 views1 answer
Delete duplicate rows
SQL
1 vote130 views1 answer
What is intersect
SQL
0 vote140 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote135 views1 answer
Postgresql like
SQL
0 vote184 views1 answer
Capabilities of sql select statements
SQL
0 vote134 views1 answer
Monthly Birthday SQL Query
SQL