Recommended tool: SQL Server Compact Toolbox

“SQL Server Compact Toolbox is an add-in for Visual Studio 2010. Supports SQL Server Compact version 3.5 and 4.0.
Adds several features in concert with Server Explorer to help your SQL Server Compact development efforts”

Download it from here.