Out of necessity, I created this template to help me move a SQL Server 2005 database to SQL Server 2005 Compact edition. This saved me a LOT of manual entry for all the DDL for the CREATE TABLE stuff. Right now all it does is the basic create table with primary key (if any). It doesn't do foreign keys, since I didn't need it.
Enjoy!
So as a rule you can recognize genuinely smart people by their ability to say things like "I don't know," "Maybe you're right," and "I don't understand x well enough."