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:
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!