/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 vote130 views2 answers
How to generate a unique random number in mysql
SQL
12 votes133 views1 answer
Env var for setting password for root user mysql docker hub
SQL
2 votes87 views1 answer
Sql select min value from multiple columns
SQL
0 vote121 views1 answer
Create a table from one field of another table
SQL
11 votes127 views1 answer
Ddl materialized view
SQL
24 votes126 views5 answers
Sql server insert into select
SQL
1 vote122 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote138 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote143 views2 answers
Impala rename column name
SQL
0 vote121 views1 answer
Count columns psql(PostreSQL)
SQL