If it does not occur, the next statement in the batch will continue to be executed ... Now with the introduction of the new method “DROP IF EXISTS” in SQL Server 2016 developers can write brief code.

Learn how to simulate the EXISTS clause in conditional statements, which is not supported by natively compiled stored procedures in SQL Server.