Return
-
Title
Formatter does not indent DROP command. -
Description
Following code is used with Formatter. The DROP command is not indented such as other reserved words:
IF EXISTS
(SELECT *
FROM INFORMATION_SCHEMA.TABLE
)
BEGIN
DROP PROCEDURE dbo.dummyproc;
PRINT 'PROCEDURE dbo.dummyproc has been dropped.';
END;
GOFormatter yields follownig code:
IF EXISTS
(SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
)
BEGIN
DROP PROCEDURE dbo.dummyproc;
PRINT 'PROCEDURE dbo.dummyproc has been dropped.';
END;
GO
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.