/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 vote265 views1 answer
Concatenate columns in table
SQL
8 votes290 views2 answers
Phpmyadmin default password
SQL
0 vote271 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
2 votes277 views1 answer
Mysql query unique column
SQL
1 vote310 views2 answers
Mysql add column tinyint default 0
SQL
2 votes266 views1 answer
Sqlite indexes
SQL
0 vote272 views1 answer
Postgres in operator with comma separated values
SQL
1 vote295 views1 answer
Key validation sql
SQL
0 vote279 views1 answer
Sql character index
SQL
3 votes332 views2 answers
Oracle drop sequence
SQL