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.