/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 vote87 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
1 vote147 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
1 vote277 views1 answer
Sql check roles
SQL
0 vote134 views1 answer
Show database not empty tables postgres
SQL
0 vote176 views1 answer
Fetching data from mysqldb
SQL
3 votes159 views2 answers
Sql not contains
SQL
0 vote135 views1 answer
Renommer table sql
SQL
3 votes132 views5 answers
Mysql get last inserted id
SQL
1 vote145 views1 answer
Add many column to sap iq table
SQL
2 votes176 views1 answer
Merge two columns in sql oracle
SQL