SQL Server Compact Toolbox is a Visual Studio add-in and standalone app , for managing all aspects of your SQL Server Compact database files
Please download the Visual Studio add-in (for both 3.5 and 4.0) from Visual Studio Gallery
Follow me on Twitter: @ErikEJAdd-in version 3.6 - October 2013 - Table Builder- Entity Framework 6 Entity Data Model - Report Viewer with PDF/DOCX/XLSX exportSQL Server Compact Toolbox 3.6Standalone 3.1 - June 2013 - Support for 3.5, LINQ to SQL codegen, Report Viewer and other new features
For similar functionality in SQL Server Management Studio and from a command line, use my SQL Compact Scripting Utility Project
Please feel free to provide feedback on bugs and feature requests using the Issue Tracker
This project is inspired by the excellent SQL Azure Explorer
CodePlex project. Thanks for being there.
For more technical information on Visual Studio add-ins, see this blog post.