>Hi everybody,
>
>I want to have a create table script which I can execute multiple times (so I would need to have drop statements first).
>
>I also would like to be able to preserve existing data.
>
>Is there a way to write such a script?
>
>Thanks a lot in advance.

Isn't there something like a temp table in sqlserver ?