>>Hi everybody,
>>
>>When I generate CREATE TABLE script it would be nice that it would add a check for the existance of the table.
>>
>>Do you remember the syntax?
>>
>>Thanks in advance.
>
>

>IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[TableNameHere]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
>  -- Table does not exists
>

>
>In Tools->Options click on Scripting node and set Include IF NOT EXISTS clause to true.

Wow, thanks a lot.