With the release of the exciting Service Pack 1 for SQL Server 2016 we get a new T-SQL command – CREATE OR ALTER.
CREATE OR ALTER <valid for procedures, views, functions, and triggers> as below for a view;
Although its interesting that intellisense still doesn’t understand it if is present already;
This is another addition that goes to make all our lives a little easier when scripting out.
Thanks for reading.
SQL Server 2016 SP1 – CREATE OR ALTER