Looking through the T-SQL updates for SQL Server 2016 this one caught my eye DROP IF EXISTS.
So when you normally drop a table for example you use IF OBJECT_ID:
IF OBJECT_ID(N'dbo.MyTable') IS NOT NULL
DROP TABLE dbo.MyTable
now you can use:
DROP TABLE IF EXISTS dbo.MyTable
It’s not just for tables you can use it for object such as:
AGGREGATE
ASSEMBLY
DATABASE
DEFAULT
FUNCTION
INDEX
PROCEDURE
ROLE
RULE
SCHEMA
SECURITY
SEQUENCE
SYNONYM
TABLE
TRIGGER
TYPE
USER
VIEW
ASSEMBLY
DATABASE
DEFAULT
FUNCTION
INDEX
PROCEDURE
ROLE
RULE
SCHEMA
SECURITY
SEQUENCE
SYNONYM
TABLE
TRIGGER
TYPE
USER
VIEW
Not in the SQL Server Blog Post that announced this update but you can also drop COLUMN and CONSTRAINT
IT Consultant on the edge 