So I have an application that's using SQL Server Compact Edition 2005. I need to export the table schema to a file of SQL statements, containing only the schema...no data, no rows, just the tables, indexes, and constraints.

Now, when using SQL 2000/2005 I just use the script table as... feature to do exactly this, but because SQL server Compact Edition doesn't have the support for it, I can't do this.

The tables in SQL Server Compact *do* have the information_schema views though, so I was wondering if anyone knows of any tools that can read these views and generate sql ce code to build the tables?