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!

RECENT POST
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. PigeonSQL.com | Filip Holub

  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon