DefaultRuleBase.Alter Method ()

Article
07/16/2015

Applies To: SQL Server 2016 Preview

Updates any Default object or Rule object property changes on instance of SQL Server.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

public void Alter()

public:
virtual void Alter() sealed

abstract Alter : unit -> unit
override Alter : unit -> unit

Public Sub Alter

Implements

IAlterable.Alter()

Remarks

The Alter method updates any changes that have been made to the Default object or Rule object properties since the object was created or since the last Alter statement. The modifications are combined and sent to the instance of SQL Server in a single network trip to the instance of SQL Server.

Examples

Legacy Code Example

Creating, Altering, and Removing Defaults

Creating, Altering, and Removing Rules