• Article

FullTextIndex.Alter Method (Boolean)

Updates any FullTextIndex object property changes on the instance of SQL Server with the option to specify whether the full-text index is automatically populated after columns are added or removed. 

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

Syntax

'Declaration
Public Sub Alter ( _
    noPopulation As Boolean _
)
'Usage
Dim instance As FullTextIndex
Dim noPopulation As Boolean

instance.Alter(noPopulation)

public void Alter(
    bool noPopulation
)

public:
void Alter(
    bool noPopulation
)

member Alter : 
        noPopulation:bool -> unit 

public function Alter(
    noPopulation : boolean
)

Parameters

  • noPopulation
    Type: System.Boolean
    A Boolean value that specifies whether the full-text index is automatically populated after columns are added or removed.
    If True, the full-text index is not automatically populated after columns are added or removed.
    If False, the full-text index is automatically populated after columns are added or removed.

Remarks

The Alter method updates any changes that have been made to the FullTextIndex object's properties since the FullTextIndex 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.