How to Create Database in SQLite Manager

To access SQLite Manager, open Firefox and look for it in the Tools menu and click SQLite Manger.

If you are not find SQLite in Firefox go to step by step guide to Install SQLite Maneger in Firefox.

When you are in SQLite Manager, you can view the basic interface. Mouse over the icons to see their functions. Use the Create Database tool to create a database. We’ll work with a “test” database for now.

To Create Database go to Database and click New Database. This will prompt to write database name and click ok and save database to any where you want.

Now, we have create a table. Right click Tables and click create table to make your first table.

For this table, name it "Nametbl”. We will add a series of fields to this table. id, name, city, genre, web.
id - a unique identifier that will be setup by SQLite Manager. Make it an integer, primary key, auto-increment and say it cannot be NULL.
name – VARCHAR
city – VARCHAR
genre – VARCHAR
web - VARCHAR

Click OK. What you are actually doing is executing this SQL statement – except the program is doing it for you.

CREATE TABLE "main"."Nametbl" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "name" VARCHAR, "city" VARCHAR, "genre" VARCHAR, "web" VARCHAR);

You should now see the Testtbl table.

Done!!