Recently I’ve stumbled upon a small nifty tool, that’ll allow you to retrieve the database schema of your SQL Compact Edition database ^.^
The tool is relatively easy to work with, provided you have the correct SQLCE runtimes installed..
In my case (having a x64 system) I had to install the x86 runtime first, and after that the x64 runtime.
Anyhow, the tool is not made by me, but it’s made by Erik Ejlskov Jensen.
You can find his blog here
The tool can be downloaded here
It’s available as an addin for SQL Server Management Studio 2008 (Express) or as a simple CLI