-
Notifications
You must be signed in to change notification settings - Fork 129
User Interface
Description of the panels and tabs of the SQLite Manager User Interface.
The SQLite Manager GUI has 3 main components; The menu bar/toolbars at the top, the *Database Objects Panel* on the left and the *Object Work Space Panel* on the right.
The Database Objects Panel serves as the navigation pane for the application.
Clicking on an object name in the panel will show the properties of that object in the Structure tab of the Object Work Space Panel and in the case of Table and View objects, the rows associated with the selected object will be displayed in the Browse & Search tab.
These elements are grouped under four categories; Tables, Views, Indexes and Triggers.
At the top of this panel, there is a drop down menu which display the name or alias of the database that currently has the focus. You can switch the focus of the panel to the connected database, temp or any attached databases that may be present by selecting it from this drop down list.
There is a feature within SQLite Manager which allows the user to minimize the *Database Objects Panel* (the left hand panel) by clicking on the center of the vertical interface of the left and right hand panels or by pressing the function key F9.
If you have inadvertently minimized the left hand panel then press F9 to bring it up again.
The Object Work Space Panel has 4 permanent tabs labeled; Structure, Browse & Search, Execute SQL and DB Settings.
There are four additional tabs which are invoked by selecting certain menu items or icons and these are; User-defined Functions, Import, Export , and On-Connect SQL.
Shows the properties and SQL CREATE statement for the object highlighted in the Database Object Panel. Table and view objects may be modified, dropped or renamed within this tab.
The Browse & Search tab lists the rows for whatever tables or view has been selected in the Database Object Panel. Will display the rows returned based on the search criteria supplied.
Enter SQL text area where SQL statements and saved queries can be run.
With the possible exception of enabling or disabling Foreign Key support, there is little need for anyone but an advanced user to change the settings on this tab.
Wizard to import data from CSV, XML or SQL format files into new or existing tables within the connected database or any attached sqlite databases.
Wizard to export a table or view to a CSV, XML or SQL format file.
Opened by clicking on the f(x) icon on the Database tool bar.
SQL statements to be run at the beginning of a database session. May be made specific to a single database or for all databases opened by SQLite Manager.
SQLite Manager does not include the SQLite library rather it uses whatever version of SQLite is in use by the application that it is attached to. The version number of SQLite being used is displayed at the bottom left hand corner of the SQLite Manager application.
You can change the font, font size, and row height in which rows are displayed in the Browse & Search tab and the Execute SQL tab in the SQLite Manager Options dialog box.
# From the Tools drop down menu, select *Options* to bring up the SQLite Manager Options dialog box. # In the dialog box click on the Data Tree Style tab # to increase the displayed print size enter a number greater than 100 in the *Enter Font Size* text box. To decrease the font size enter a number less than 100. To change the font enter the font name in the *Font Family* text box, for example "Courier New" or "Times New Roman". # Click the Apply button and then the Ok button on the tabthe tab.