Project Description
SQL Server Compact Edition Database Query Analyzer

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 fields, nullable fields)
- Displays the information schema views
- Displays column information (database type, clr type, max length, allows null, etc)
- Displays index information (column name, is unique, is clustered)
- Execute SQL Queries against a SQL Server Compact Edition database
- Execute multiple SQL queries (delimited by a semi colon ;)
- Easily edit the contents of the database
- Display query result as XML
- Shrink and Compact Databases
- SDF file association with SQL Compact Query Analyzer for launching directly by opening the SDF in Windows Explorer
- Displays thumbnails for IMAGE fields
- Generates Schema and Data Scripts
- Supports password protected databases
- Supports SQLCE 3.0, 3.1, 3.5 and 4.0

Coming at some point:
- Purge database content
- Create, edit, and drop tables UI
- Create, edit, and delete table references and indexes UI
- Support for SQL Server Compact Edition 2.0


Screenshots


- Displays database and schema information and executes multiple SQL queries directly


- Edit the table data directly


- Display the contents of IMAGE fields


- Performance numbers for queries


- Query errors


- Output result set as XML


- Create new database


- Shrink, compact, script database

Prerequisites:
- .NET Framework 4.0


For tips and tricks on mobile development, check out my blog
http://christian-helle.blogspot.com

Follow me on Twitter
http://twitter.com/christianhelle


Last edited May 24, 2013 at 10:41 PM by christianhelle, version 25