When using a “normal” MsSql database (whatever the version), the management tool allow us to create a “database generation script”.
This option does not exists for SqlCE Databases (soooo sad).
Here is a little third-party tools that woes the trick…
Among creating “scripts”, the add-in adds the following menu items to the table context menu in Object Explorer:
– Show Table Data (browse, sort, edit, import/export/delete images, refresh data)
– Script Table as CREATE, DROP, SELECT, INSERT, UPDATE, DELETE and INSERTs (data) to New Query Editor Windows/File/Clipboard
– Import Data from CSV