A SQL Server Compact Edition Database Query Analyzer
Download latest release here
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
If you find this useful and feel a bit generous then feel free to buy me a coffee ☕
