SQL Compact Query Analyzer favicon

SQL Compact 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