How can I create a sequence in SQLite?

If you mean that you want the primary key to be autogenerated, then look at AUTOINCREMENT when creating your table:

• SQLite CREATE TABLE syntax.

create table Categories (
    pk_categoryid integer primary key autoincrement, 
    category_name text
);