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