Creating `sqlite_sequence` table gets error

The sqlite_sequence table gets generated automatically when you assign a data field of a table to autoincrement (e.g. _id integer primary key autoincrement)

It is impossible to create table called sqlite_sequence manually because "Table Name cannot begin with sqlite_ as the object name reserved for internal use: SQLITE_SEQUENCE"

The only missing on your DDL is that it lacks datatypes on the columns,

CREATE TABLE sqlite_sequence
(
    name VARCHAR(20),
    seq INT
);

• SQLFiddle Demo

UPDATE 1

• MySQL Data Types

You need to specify the data types for name and seq.

Try:

create table SQLITE_SEQUENCE ( name varchar(255), seq int );

define data type for fields(columns)

CREATE TABLE sqlite_sequence(name varchar(200),seq int(8));

Here is a normal create table command for reference:

CREATE TABLE demo (id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE DEFAULT 0,name text);

And yeah there's no problem with the INSERT command.

You have to define data type after each table field Like this:

CREATE TABLE sqlite_sequence (
                name VARCHAR(45),   
                seq INT
              );

In SQLite, you cannot manually create sqlite_sequence table because sqlite_sequence table is reserved to create it with AUTOINCREMENT internally.

The doc says below:

SQLite keeps track of the largest ROWID using an internal table named "sqlite_sequence". The sqlite_sequence table is created and initialized automatically whenever a normal table that contains an AUTOINCREMENT column is created.

So, if you try to manually create sqlite_sequence table as shown below:

CREATE TABLE sqlite_sequence (
  name TEXT
);

Then, you get the error below:

Parse error: object name reserved for internal use: sqlite_sequence