• Welcome to SQLitening Support Forum. Please login.
 
December 03, 2021, 07:03:39 PM

News:

Welcome to the SQLitening support forums!


DbSystemViewer for SQLite

Started by Rolf Brandt, September 02, 2013, 01:33:10 PM

Previous topic - Next topic

Rolf Brandt

September 02, 2013, 01:33:10 PM Last Edit: September 03, 2013, 04:03:19 AM by Rolf Brandt
Here is a little tool that I have written for myself to examine SQLite databases  It lists all tables, indexes, triggers, etc. in the database. It also shows all SQL commands that were used to create the database. This is done by reading the sqlite_master table, a system table where SQLite stores its information about the structure of the database.

You can copy the different SQL commands that created the database to the clipboard to use them. You also can quickly create a new empty copy of a database.

SQLite3.dll needs to be on your computer, either in the Windows, System32, or your program folder.

Maybe it is useful for someone else. Comments are welcome. The tool was written in PowerBasic 10 and PlanetSquires FireFly 3 (http://www.planetsquires.com/) as Visual Designer.

Rolf
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Fredrick Ughimi

Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Marty Francom

Thanks... I found that app to be useful.