/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 vote115 views1 answer
Char varchar nvarchar sql
SQL
0 vote118 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote74 views2 answers
Sql query unique
SQL
0 vote116 views1 answer
Change role postgres
SQL
8 votes166 views2 answers
Oracle auto increment primary key
SQL
1 vote164 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote152 views1 answer
Select milliseconds mysql
SQL
0 vote108 views1 answer
Show specific events on mysql
SQL
2 votes162 views1 answer
Sql compare strings
SQL
1 vote110 views1 answer
Oracle aleter trigger ora-01031
SQL