Portable SQL Compact Query Analyzer

Portable SQL Compact Query Analyzer is a simple, useful and effective application worth having when you need to create and run SQL queries.

The utility comes with the same functionality, interface and options as SQL Compact Query Analyzer. Still, we dare say it is more advantageous than the latter, since you can carry it around on a removable drive and it does not affect the computer’s registry, nor interact with other installed software.

The main window of the application is quite simple and enables you to display database and schema information, then directly execute SQL queries so you can create new tables, fields and procedures.

What’s more, you can even execute SQL scripts against a SQL Server Compact Edition database and edit the content of each database.

Being sectioned in three panels, from the left corner you are able to view all the database information including tables, callers, samples, threads and classes while the below panel enables you to view if any errors are produced each time you try to run a SQL query.

Also, by using Portable SQL Compact Query Analyzer you are able to view schema summary such as columns, primary keys and identity fields.

The applications aims to provide you with an effective and reliable GUI from where you can easily add your personal tables, edit each column and generate data scripts.

To wrap it up, Portable SQL Compact Query Analyzer proves to be a straightforward program when it comes to creating new tables and procedures by executing SQL queries.