When I create a temporary table, I usually make sure that if they exist, I drop them.
IF OBJECT_ID(N'tempdb..#tempTable') IS NOT NULL
DROP TABLE #tempTable
I recently realized that the following method does the same:
DROP TABLE IF EXISTS #tempTable
Is there one way better than the other ?
Explanation
They do the same thing just different syntax, and the later method in your question is newer. The IF EXISTS clause has been supported with DROP TABLE since SQL Server 2016 13.x up through the current version as of writting this, SQL Server 2019 (15.x).
Documentation
The IF EXISTS functionality is documented in the arguments section here: https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-table-transact-sql?view=sql-server-ver15#arguments