SQL Server 2019 (Linux)

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

CREATE TABLE #Schools(
[Name] varchar(250),
[Grade] varchar(150),
[City] varchar(150));
DROP TABLE #Universities;
Msg 3701 Level 11 State 5 Line 1
Cannot drop the table '#Universities', because it does not exist or you do not have permission.

IF OBJECT_ID('tempdb..#Universities') IS NOT NULL 
DROP TABLE #Universities
IF OBJECT_ID('tempdb..#Schools') IS NOT NULL 
DROP TABLE #Schools
SELECT *
FROM #Schools
Msg 208 Level 16 State 0 Line 1
Invalid object name '#Schools'.