/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

2 votes264 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote268 views1 answer
Postgres execute multiple sql file from command line
SQL
5 votes279 views3 answers
Postgres show databases
SQL
2 votes253 views1 answer
Oracle create directory
SQL
3 votes216 views2 answers
Mysql sum with condition
SQL
0 vote269 views1 answer
Sql last time database was accessed
SQL
0 vote275 views1 answer
Postrgres trunc
SQL
2 votes257 views2 answers
How to get capital letter first in sql
SQL
0 vote287 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote302 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL