SQL Server 2016 SP1 – CREATE OR ALTER

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;

CREATE or ALTER 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

Leave a Reply

Your email address will not be published.

Pin It on Pinterest