How do I view a Microsoft SQL Server Compact Database
After OP's Edit to the question :
Try to use Visual Studio 2010 SP1 + VS Tools for SQL CE 4
-- or --
SQL Server Management Studio 2008 R2 supports for SQL Server Compact 3.5 database. (ATTENTION from SSMS version 2012 and newer, Sql Server Compact databases are no longer supported by SSMS; You must use SSMS 2008 R2 or OLDER)
Note : SQL Server Management Studio cannot open SQL Server Compact 4 files, only SQL Server Compact 3.5 files.
Click View &gt;&gt;Toolbars &gt;&gt;SQL Server Compact Edition Editor as shown.

Additionally, refer to SQL Compact 3rd party tools and
SQL Server Compact Toolbox on Codeplex - It is a Visual Studio add-in and standalone app , for managing all aspects of your SQL Server Compact database files.