This topic has not yet been rated - Rate this topic

DefaultRuleBase.Alter Method

SQL Server 2012

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

C++

JScript

public void 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

Creating, Altering, and Removing Defaults

Creating, Altering, and Removing Rules

Reference

DefaultRuleBase Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Working with Database Objects

Rules

Defaults

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD