Demo code for the DROP TABLE IF EXISTS "bug"

DropIfExistsTableBug.sql

DROP TABLE IF EXISTS dbo.ObjectFormerlyATable;

CREATE TABLE dbo.ObjectFormerlyATable
(
	ID INT IDENTITY(1,1) NOT NULL
	CONSTRAINT PK_dbo_ObjectFormerlyATable PRIMARY KEY CLUSTERED (ID ASC)
);

INSERT INTO dbo.ObjectFormerlyATable DEFAULT VALUES;

SELECT ID FROM dbo.ObjectFormerlyATable;

DROP TABLE IF EXISTS dbo.ObjectFormerlyATable;
GO

CREATE OR ALTER VIEW dbo.ObjectFormerlyATable
AS
SELECT
	ID=1
;
GO

SELECT ID FROM dbo.ObjectFormerlyATable;