SQL Compact Query Analyzer is described as 'Features: - Create new database - Automatically refresh database upon executing create/alter/drop table queries - Displays database information (database version, filename, size, creation date) - Displays schema summary (number of tables, columns, primary keys, identity'. There are four alternatives to SQL Compact Query Analyzer for Windows and .NET Framework. The best alternative is LINQPad, which is free. Other great apps like SQL Compact Query Analyzer are Database .NET (Free Personal), CompactView (Free, Open Source) and Microsoft SQL Server Compact (Free).
LINQPad lets you interactively query SQL databases in a modern query language: LINQ. Kiss goodbye to SQL Management Studio! LINQPad supports everything in C# 3.0 and Framework 3.5: LINQ to Objects LINQ to SQL Entity Framework LINQ to XML (Even old-fashioned SQL!
Database .NET is an innovative, powerful and intuitive multiple database management tool. With it you can Browse objects, Design tables, Edit rows, Export data and run Queries with a consistent interface. A standalone tool that does not require installation.
CompactView is a viewer for Microsoft® SQL Server® Compact Edition (SQLCE) database files (*.sdf). CompactView can open database files of versions 3.1, 3.5 and 4.0. CompactView need the following installed software to run it: