SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t(i INT);
INSERT INTO t(i) VALUES(1);
1 rows affected

CREATE PROCEDURE proc1
AS
BEGIN
  DROP TABLE IF EXISTS t;
  DROP PROCEDURE IF EXISTS proc1;
END;
SELECT * FROM t


i


1


EXEC proc1;
SELECT * FROM t
Msg 208 Level 16 State 1 Line 1
Invalid object name 't'.

EXEC proc1; -- Could not find stored procedure 'proc1'.
Msg 2812 Level 16 State 62 Line 1
Could not find stored procedure 'proc1'.