/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 vote197 views1 answer
Mysql c commands
SQL
11 votes159 views2 answers
Having clause in sql
SQL
7 votes152 views3 answers
How to check table name in current database sql
SQL
0 vote180 views1 answer
Getting next sequence value jpa postgress
SQL
2 votes179 views1 answer
Laravel sql String
SQL
4 votes106 views1 answer
Generate class from sql table c#
SQL
0 vote171 views1 answer
Str_to_date sql server
SQL
0 vote154 views1 answer
Sql server datetime to string
SQL
2 votes161 views1 answer
Oracle convert run_duration to number
SQL
3 votes167 views3 answers
Create table in microsoft sql server
SQL