/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 vote327 views1 answer
Mysql installer no packages found
SQL
4 votes336 views1 answer
Force drop all tables postgres
SQL
0 vote281 views1 answer
Ms sql print more than 1 variable
SQL
4 votes342 views2 answers
Select first and last row mysql
SQL
-1 vote282 views2 answers
Datetime sql server week
SQL
0 vote321 views1 answer
Select password from user mysql
SQL
3 votes344 views1 answer
Force using index plsql
SQL
5 votes358 views4 answers
Restart the psql server windows
SQL
8 votes339 views1 answer
Oracle add months to sysdate
SQL
0 vote361 views1 answer
Query to remove duplicate rows from a table
SQL