/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

10 votes170 views4 answers
Drop primary key
SQL
0 vote197 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
2 votes208 views1 answer
Sql server: select column values as comma separated string
SQL
11 votes214 views2 answers
Having keyword sql
SQL
0 vote171 views1 answer
How to check even or odd in sql
SQL
6 votes203 views2 answers
Mysql check auto increment value
SQL
0 vote177 views1 answer
Product of a column in mysql
SQL
0 vote174 views1 answer
Automatically update database last seen datetime in sql
SQL
5 votes270 views1 answer
Oracle asynchronous procedure
SQL
0 vote164 views1 answer
Get all employees if name ends with in sql
SQL