Old method: Prior to SQL Server using drop if exits on database objects Using the DROP IF EXISTS method before SQL Server 2016 required writing lengthy IF statement wrappers code.