>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)
In Tools->Options click on Scripting node and set Include IF NOT EXISTS clause to true.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
