Sql Create Statement Incorrect Syntax Near Auto Increment

SQL create statement incorrect syntax near auto increment

It is IDENTITY not AUTO_INCREMENT in SQL Server.

Try this instead:

CREATE TABLE [dbo].[MY_TABLE] (
    [ID] INT NOT NULL IDENTITY(1, 1),
    [NAME]          NVARCHAR (100) NULL,
    [SCHOOL]             NVARCHAR (100) NULL,
    PRIMARY KEY (ID)
);

SQL Server 2019 ProgrammingError: Incorrect syntax near 'AUTO_INCREMENT'

SQL Server doesn't support auto-increment. Nor does SQL Server -- or any other database -- support single quotes for column names (as far as I know).

I would recommend writing the statement as:

CREATE TABLE sqlalchemy_generic_types (
    sqlalchemy_generic_type_id INT IDENTITY(1, 1) PRIMARY KEY,
    ObjectName VARCHAR(25) NOT NULL,
    Description VARCHAR(100) NOT NULL
);

Note the changes:

• IDENTITY() is assigns an increasing value to the id.
• The id is given a meaningful name.
• The space is removed from ObjectName, so the name does not need to be escaped.
• No escape characters are needed to define the table.

Incorrect syntax near ',' on AUTOINCREMENT on table creation

try this for SQL Server as from Error It is Sql Server's Error

string sqlStatement = "CREATE TABLE " + Table1Name + "" 
                    + " (network_id INTEGER identity(1,1) PRIMARY KEY,"
                    + "network_full_name VARCHAR(50) NOT NULL)";

BEWARE OF SQL INJECTION

Auto increment syntax errors

Below code worked for me:

CREATE TABLE user_Info (
   [admin] int IDENTITY(1,1) PRIMARY KEY,
   [Username]  NVARCHAR (50) NOT NULL,
   [Password]  NVARCHAR (50) NOT NULL,
   [Firstname] NVARCHAR (50) NOT NULL,
   [Lastname]  NVARCHAR (50) NOT NULL,
   [Email]     NVARCHAR (50) NOT NULL,
   [Country]   NVARCHAR (50) NOT NULL,
   [Phone]     NVARCHAR (50) NOT NULL,
   [Gender]    NVARCHAR (50) NOT NULL,
);

syntax error in sql server 2008 for AUTO_INCREMENT

Try using IDENTITY instead of AUTO_INCREMENT.

CREATE TABLE products
(
    ID int NOT NULL IDENTITY(1, 1),
    Name varchar(255) NOT NULL,
    Description varchar(255),
    PRIMARY KEY(ID)
);

AUTO_INCREMENT doesn't work in SQL server 2012?

Missing closing ) and using incorrect syntax for an IDENTITY field.

CREATE TABLE detectives(
    id INT IDENTITY,
    first_name VARCHAR(50),
    last_name VARCHAR(50) NOT NULL,
    phone_number VARCHAR(10) NOT NULL,
    certification_date DATE NOT NULL,
    CONSTRAINT detectives_pk PRIMARY KEY (id)
    )

I get the error incorrect syntax near ... in Microsoft SQL Server Management Studio

If you are using MySQL the following is the syntax:

create table Countries
(
    Id INT NOT NULL AUTO_INCREMENT,
    Name VARCHAR(50) NOT NULL,
    PRIMARY KEY (Id)
);

If you are using MSSQL the following is the syntax:

create table Countries
(
    Id INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
    Name VARCHAR(50) NOT NULL
);

SQL Server 2008 R2. Incorrect syntax near 'AUTO_INCREMENT'

CREATE TABLE Person(
P_Id int NOT NULL IDENTITY(1,1) PRIMARY KEY,
Name varchar(255))

You should explicitly state whether NAME is NULL or NOT NULL so you are not dependant upon the current connection settings that happen to be in effect.

---

Related Topics