/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

18 votes173 views3 answers
Mysql number format
SQL
2 votes181 views2 answers
Change varchar length mysql
SQL
6 votes214 views3 answers
Psql show columns of table
SQL
0 vote173 views1 answer
How to to get current date in sql
SQL
0 vote163 views2 answers
Find Overlapping sql
SQL
-1 vote185 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote182 views1 answer
Foreign key multiple columns
SQL
1 vote166 views1 answer
Sql server read uncommitted
SQL
0 vote227 views1 answer
Hierarchal database table
SQL
1 vote183 views2 answers
Sql insert timestamp
SQL