/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 vote180 views1 answer
Oracle job class
SQL
0 vote205 views1 answer
Sql injection payload list github
SQL
0 vote200 views1 answer
Mysql cast null to string
SQL
14 votes181 views3 answers
Delete all records from table except sql
SQL
2 votes189 views1 answer
Set username and password for postgresql database
SQL
2 votes187 views1 answer
Mysql sysdate - 1 day
SQL
0 vote174 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote192 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote243 views1 answer
Drop view sql
SQL
0 vote210 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL