InAlter Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The InAlter property reports the change mode of a Table object.

Syntax

object
.InAlter

Parts

  • object
    An expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT InAlter(LPBOOL pRetVal);

Remarks

If TRUE, the BeginAlter method has been used to mark the start of a unit of change for the Tableobject. The DoAlter method commits any changes made within the unit. The CancelAlter method rolls back any changes made.

If FALSE, no change unit exists. Changes made to the Table object properties, methods that affect the referenced Microsoft SQL Server table, and modification to the Table object collections cause immediate update requests to the instance of SQL Server.

Applies To: