
SQL Compact Query Analyzer alternatives
SQL Compact Query Analyzer is a stand-alone tool for querying and manipulating SQLCE (SQL Server Compact) databases. It provides rich visualizations of database structure, provides an intuitive interface for easy exploration of data, and provides quick access to common database operations such as create, read, update, and delete. It gives you access to the most common tasks like viewing table data, modifying data, executing queries, schema browsing, and more.
You can use the Query Analyzer to perform data entry into SQLCE databases, and you can view SQLCE system tables, including the database structure and the table data. The Query Analyzer also provides an interface with which you can execute Transact-SQL queries against an SQLCE database. The Query Analyzer works with all editions of Microsoft SQL Server Compact Edition (SQL Server CE), as well as with all versions of the SQL Server Compact databases. It supports features like Schema modifications, XML Indexing, Columnstore Indexing, Data type conversions, etc.
















































