/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 vote328 views1 answer
Access the postgres psql
SQL
1 vote338 views1 answer
Mysql check table exists
SQL
1 vote317 views2 answers
Sql multiline comment
SQL
0 vote401 views1 answer
Compress sql file database ubuntu
SQL
0 vote334 views1 answer
With_for_update sqlalchemy
SQL
1 vote344 views1 answer
What is a Database?
SQL
5 votes323 views2 answers
Get columns number sql
SQL
1 vote561 views1 answer
Postgres convert text to number
SQL
5 votes306 views6 answers
Sql add days to date
SQL
22 votes358 views3 answers
Year format in date mysql
SQL