Toad World® Forums

Regarding CaseID:927214 - DDL Creation generates code to drop Schema, which when run Fails on Toad-ss 5.5

Regarding CaseID:927214 - DDL Creation generates code to drop Schema, which when run Fails on Toad-ss 5.5

Gita,

  1. I performed the DDL creation again. This time, the ‘If Exist’
    statement was fully created… Meaning I missed it and you caught it…

  2. Please close the case, problem cannot be reproduced.

  3. My Bad !!!

IF (EXISTS

(SELECT *

FROM sys.stats

WHERE object_id = OBJECT_ID (N’[dbo].[Prospectlist]’)

AND name = N’_WA_Sys_00000024_182C9B23’))

BEGIN

DROP STATISTICS [dbo].[Prospectlist].[_WA_Sys_00000024_182C9B23]

END

GO

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype