SQL Compact Query Analyzer

As the name suggests, SQL Compact Query Analyzer is a specialized tool designed to facilitate the manipulation and queuing of SQLCE databases.

The app comes with an installer and archive, the latter enabling a quicker setup by simply decompressing the archive and launching the executable. The app comes with a minimalistic and clean interface that is unlikely to give you troubles regardless of your experience with similar tools.

In fact, as soon as you launch the tool, it prompts you to browse for the SDF file you want to manage. Once loaded, the app displays all content available within the database along with a few extra options. It is important to note that the tool is compatible with SqlCe versions 3.0, 3.1, 3.5 and 4.0. Using files that were created with other versions could lead to errors or the app will not be able to read the SDF.

Functionality-wise, the tool is as simple to use as it looks. Once you load the desired file, it can display general information on the database, such as file name, creation date and time, version and file size. Moreover, it can shows you if the database is protected by a password and it comes with schema summary and information.

At the same time, it mentions the number of tables, columns, primary keys, identity and nullable files and enables you to check out columns, indexes, tables and referential constraints. It is worth mentioning that the tool allows you to change text inside entries and view table data and allows you to change text inside entries and view table data.

SQL Compact Query Analyzer is a reliable tool that can come in handy for anyone needing a lightweight solution for viewing, managing and analyzing queries.