/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 vote106 views1 answer
Sql string function update replace
SQL
0 vote108 views1 answer
Power query datetime to date
SQL
0 vote124 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote109 views1 answer
Sql find gaps in date ranges
SQL
1 vote106 views1 answer
Mysql list bigger table
SQL
0 vote110 views1 answer
Redudancy in SQL
SQL
0 vote107 views1 answer
Oracle drop default value
SQL
1 vote111 views1 answer
Postgresql how to show table names
SQL
1 vote103 views1 answer
Mysql view current queries
SQL
0 vote108 views1 answer
Sql convert unix time to date
SQL