/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

13 votes211 views2 answers
Sql join
SQL
3 votes252 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote208 views1 answer
Oracle create job if not exists
SQL
0 vote228 views1 answer
Psql generate id in existing database
SQL
0 vote199 views1 answer
Oracle dynamic select into
SQL
1 vote211 views1 answer
How to truncate a table in databse
SQL
0 vote290 views1 answer
Do you know sql
SQL
0 vote198 views1 answer
Fix sqlite3 ruby on rails
SQL
2 votes198 views1 answer
Mysql increment value by 1 in update
SQL
0 vote201 views2 answers
Alter table add multiple columns mysql
SQL