/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

5 votes357 views1 answer
Purge undo tablespace usage
SQL
0 vote391 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
1 vote301 views1 answer
Delete triger pl pg sql
SQL
0 vote331 views1 answer
Select 1 from orders
SQL
0 vote351 views2 answers
How to prevent sql injection in java
SQL
0 vote350 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote362 views1 answer
Create table split string function in sql server
SQL
0 vote339 views1 answer
Assign value to var in SQL
SQL
0 vote327 views1 answer
Show table structure mysql console
SQL
0 vote345 views1 answer
Hour differeence in mysql
SQL