Could you please any one answer correct the query

Question

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.

Arun Kumar Tiwari · 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) );

Jaimin Shethiya · Answer

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

Debasis Mohapatra · Answer

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 Palanivel · Answer

Hi Debasis, which database server you are using? Is it mysql or sql server?

Salman Beg · Answer

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 Palanivel · Answer

Hi Debasis, Please alter the query like CREATE TABLE sites ( [id] INT NOT NULL AUTO_INCREMENT, name VARCHAR (50), PRIMARY KEY ([id]) );