Could you please any one answer correct the query

Debasis Mohapatra

6y2kSQL

Hi,

could you please any one guide me why i am getting the error

CREATE TABLE sites (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT

);

Incorrect syntax near 'AUTO_INCREMENT

i have changed to

CREATE TABLE sites (

[id] INTEGER PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50)

);

WHY THE SAME ERROR IS COMMING. COULD ANY ONE RESOLVED THE ISSUE.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arun Kumar Tiwari6y ago
Accepted answer
Hi Debasis,

It is IDENTITY not AUTO_INCREMENT in SQL Server.

Try this instead:

CREATE TABLE [dbo].[sites] (
    [ID] INTeger NOT NULL IDENTITY(1, 1),
    [NAME]        text,
    PRIMARY KEY (ID)
);
Debasis Mohapatra6y ago
Please find the below sql query

CREATE TABLE sites (
id [int] IDENTITY(1,1) NOT NULL,
name TEXT,
CONSTRAINT [PK_sites] PRIMARY KEY CLUSTERED
(
id ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

simple way you can do

CREATE TABLE sites1 (
[id] INT NOT NULL IDENTITY(1,1),
name VARCHAR(50),
PRIMARY KEY ([id])
);
Ramesh Palanivel6y ago
Hi Debasis,

which database server you are using? Is it mysql or sql server?
Jaimin Shethiya6y ago
Hello,

can you please try below script.

CREATE TABLE sites (
[id] INT IDENTITY(1,1) NOT NULL,
name VARCHAR(50),
CONSTRAINT [PK_sites_Id] PRIMARY KEY CLUSTERED
(
[Id] ASC
)
);

let me know if you have needed any other things.

Thanks
Salman Beg6y ago
Hi. In SQL server Auto-increment is not exists. So you need to use identity in place of that. Follow up with this link for details, https://www.w3schools.com/sql/sql_autoincrement.asp
Ramesh Palanivel6y ago
Hi Debasis,
Please alter the query like
CREATE TABLE sites (
[id] INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
PRIMARY KEY ([id])
);