/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 vote133 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote151 views1 answer
Convert rows into columns in oracle
SQL
0 vote132 views1 answer
Order by with where clause in mysql
SQL
1 vote131 views1 answer
Postgres check blocking
SQL
0 vote124 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
-2 votes142 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote170 views2 answers
How to prevent sql injection in java
SQL
0 vote124 views1 answer
Sql select lowest value row
SQL
-1 vote139 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote135 views1 answer
Psql list view rules
SQL