For example, you can run a simple SELECT statement such as “SELECT column FROM table”. The queries are run just like you would normally see in any SQLite browsing environment. In this enhanced SQLite Viewer, examiners even have the ability to run SQL queries on the open database using the Build Query function right within the AXIOM interface. When the funnel icon is clicked in the header of the column, a menu will appear allowing the examiner to choose to display certain rows based on the criteria entered by the user. Simply hit Clear next to the string search text box to remove the search hit view and return to all rows being displayed.Įach column in the table has filtering functionality. The string will be highlighted where it is found within the table. Using the Find button, you can perform a string search within the table that is open. You can easily recheck the columns at any time if you wish to see them again. Just by unchecking the unwanted columns, they will disappear from your view, helping to avoid too much clutter. The Show/Hide button will give the ability to toggle columns on and off, so you can choose narrow down the fields to be shown. The number of lines that are found in each table will be in parenthesis next to the table name in the dropdown menu. Using the dropdown, you can browse different tables within the database. Viewer will open on the right side of the user interface.Īs you can see in the screen above, many options are now available for you to utilize when reviewing the database file. To utilize the new features in AXIOM Examine, first select any SQLiteĭatabase file in the File System view, regardless of file extension. You can even export directly from these tables into both.

This includes the ability to hide and filter on columns, search tables, and perform custom SQL queries. Now, we’ve added the ability for examiners to truly be able to dig deep and present their findings in a useful manner. In previous versions of AXIOM, we allowed you to see the data within the SQLite databases within your case, but interacting with the data was limited.

Open sqlite file in access