This is where a tool like SQL CE Console comes in handy. It's a ~A$70 tool from Primeworks that lets you create and edit SQL CE databases on your desktop. It's not the best looking tool in the world but it does it's job well.
Here's a few of it's nice features:
1. Open databases either on the device or on your local desktop
2. View contents of a table (note the statistics at the bottom in the messages window)
3. Run arbitrary queries - note that only the highlighted text was executed in this picture
Overall, I've found this to be a handy little utility and something that I'll slip into my toolbox for future reference.