Regarding CaseID:927214 - DDL Creation generates code to drop Schema, which when run Fails on Toad-ss 5.5
Gita,
-
I performed the DDL creation again. This time, the ‘If Exist’
statement was fully created… Meaning I missed it and you caught it… -
Please close the case, problem cannot be reproduced.
-
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
678-414-0090 my cell Primary
hank.freeman50 via Skype