/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

4 votes248 views1 answer
Oracle error compilation line
SQL
0 vote268 views1 answer
Sql show table name in result
SQL
0 vote250 views1 answer
Porcentaje sql
SQL
1 vote216 views1 answer
Alter user mysql native password
SQL
11 votes264 views1 answer
Get ddl materialized view oracle
SQL
15 votes267 views5 answers
If null mysql
SQL
0 vote259 views1 answer
Connect to ssms with python
SQL
24 votes285 views4 answers
Postgres delete database
SQL
4 votes252 views1 answer
T-sql get duplicate rows
SQL
3 votes263 views2 answers
Mysql config user password
SQL