SQLitening Support Forum

SQLitening Support => You've got Questions? We've got Answers! => Topic started by: Rolf Brandt on September 02, 2013, 01:33:10 PM

Title: DbSystemViewer for SQLite
Post by: Rolf Brandt on September 02, 2013, 01:33:10 PM
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/ (http://www.planetsquires.com/)) as Visual Designer.

Rolf
Title: Re: DbSystemViewer for SQLite
Post by: Fredrick Ughimi on September 05, 2013, 10:49:55 PM
Thanks Rolf for sharing.
Title: Re: DbSystemViewer for SQLite
Post by: Marty Francom on February 05, 2014, 04:02:36 PM
Thanks... I found that app to be useful.