SQLiteDatabaseManager

SQLite DatabaseManager is a SQLite Database IDE. A free graphical user interface, that allows to perform several database tasks, its light and great for beginners.

Features

• Create SQLite connections.
• Create SQLite database files.
• Create Database objects (tables, indexes, triggers, views)
• Execute SQL statements: DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language)
• Open and Save .sql files.

Table of Contents

• Creating SQLite Connection
• Creating SQLite Database Files
• Creating Tables
• Creating Indexes
• Creating Triggers
• Creating Views

Creating SQLite Connection

Feature to add to your connections any existing SQLite database file you have. Currently only works with (.sqlite) extension files

Creating SQLite Database Files

Feature to create a SQLite database file, you have to select the location of the file and input the name of the database.

Creating Tables

Module to create a table in the current selected database, set a table Name and add columns. This form has one tab to see the generated DLL, which you can analyze before creating the table.

Creating Indexes

The create trigger module allows the developer to add indexes to the selected table. To access this module expand the desired table, right click on the option Indexes and 'Create index'

Creating Triggers

The create trigger module allows the developer to add triggers to the selected table. To access this module expand the desired table, right click on the option Triggers and 'Create trigger'

Creating Views

Create views module allows you to create a view on the SQLite database, to create a view right click on the Views option and select the 'Create View' item.

Icons Attributions

• Icons made by Freepik from www.flaticon.com
• Icons made by Smash Icons from www.flaticon.com
• Icons made by Pixel Buddha from www.flaticon.com
• Icons made by Dave Gandy from www.flaticon.com