Create Or Alter in SQL Server 2016 Servcie Pack 1

Microsoft released Service Pack 1 for SQL Server 2016 in November. SP 1 is included new feature "CREATE OR ALTER" statement. This statement creates object if it does not exist, or alter it if is already exist. We can use for these objects:

• VIEWS

• STORED PROCEDURES

• FUNCTIONS

• TRIGGERS

Unfortunately, you cannot use for "TABLE, INDEX and CLR Proceudre".

For me is it very good options, because as you well know, save it this command:

And when you compare with CREATE OR ALTER:

Have a nice day!