/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

0 vote117 views1 answer
Sql check if column exists
SQL
0 vote115 views1 answer
Mysql repair a table
SQL
0 vote105 views1 answer
Parsing float to int in mysql
SQL
0 vote125 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote115 views1 answer
Postgres where
SQL
0 vote90 views1 answer
CREATE MULTIPLE FK
SQL
4 votes112 views2 answers
REST API
SQL
0 vote116 views2 answers
Sqlite
SQL
-1 vote121 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote102 views1 answer
Reading from right to left from string find first special characters in sql
SQL