Share via


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.

Examples

Implementing Full-Text Search

See Also

Reference

FullTextIndex Class

Alter Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DEL - Full-Text Search Overview

CREATE FULLTEXT INDEX (Transact-SQL)