ScriptingOptions.ScriptForCreateOrAlter Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Scripts object using "CREATE OR ALTER" syntax.
public bool ScriptForCreateOrAlter { get; set; }member this.ScriptForCreateOrAlter : bool with get, setPublic Property ScriptForCreateOrAlter As BooleanProperty Value
Remarks
This setting is not supported for all object types, and only works when the destination is SQL Server 2016 Service Pack 1+. If toggled from true to false, the script behavior will change to CREATE for all objects. When set to true: 1. Objects that do not support "CREATE OR ALTER" will be scripted as CREATE. Their script content will also depend on the value of the IncludeIfNotExists property. 2. Objects that support "CREATE OR ALTER" will ignore the IncludeIfNotExists property.