>Right click on the table in SSMS and pick one of the scripting choices. Drop and create is probably best if you want to modify it after the first run.
>
>You can also right click the database itself and reproduce the entire structure with the script you can create from there.

Thanks, this is exactly what I wanted.