>>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 ?

Found this in my PM
create table #test (Fld1 int)
SELECT OBJECT_ID('TempDb..#test'), OBJECT_ID('#test')
DROP TABLE #Test