Sqliteexception: Near "references": Syntax Error

String CREATE_ASSIGNMENTS_TABLE= 'create table ' + ASSIGNMENTS + '(' + TITLE + ' text not null, ' + DESCRIPTION + ' text not null, ' + REFERENCES + ' text n

Solution 1:

REFERENCES is a keyword in SQL syntax. Either change the column name or quote it in backticks:

`REFERENCES`