/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 votes236 views1 answer
Mysql query first character
SQL
0 vote193 views4 answers
How to drop all tables in sql
SQL
1 vote241 views1 answer
Select not matching data with join table
SQL
0 vote181 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote242 views1 answer
How to pass list as parameter in SQL query
SQL
14 votes199 views2 answers
Oracle export trigger ddl
SQL
3 votes188 views2 answers
Mysql update row
SQL
1 vote192 views1 answer
MySQL AND Operator
SQL
3 votes197 views1 answer
Select count from table mysql
SQL
5 votes208 views2 answers
Oracle list columns
SQL