CreateFTSIndex Method

In This Topic

Create special index to use by full text search. Identity columns may not be used for FullTextSearch indexes. Only a single FullTextSearch index may exist per table.

Syntax

Visual Basic
C#

'Declaration
 
Sub CreateFTSIndex( _
   ByVal name As System.String, _
   ByVal columns As System.String _
)

'Usage
 
Dim instance As IVistaDBTable
Dim name As System.String
Dim columns As System.String
 
instance.CreateFTSIndex(name, columns)

void CreateFTSIndex( 
   System.string name,
   System.string columns
)

Parameters

name: index name
columns: Table columns participating full text index. These names are listed in the same string and separated with ';' sign

Remarks

DDA cannot query the FullTextSearch indexes. Only the SQL CONTAINS command operates on Full Text Search (FTS) indexes.

Example

The following example creates an FullTextSearch Index on multiple columns.

using( IVistaDBDatabase db = DDAObj.OpenDatabase(dbName, VistaDBDatabaseOpenMode.ExclusiveReadWrite, null) )
{
    using( IVistaDBTable table = db.OpenTable("testtable", false, false) )
    {
        table.CreateFTSIndex("FTSTest", "col1;col2;col3;col4");
    }
}

CREATE FULLTEXT INDEX indexname on tablename(columnname,...)

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IVistaDBTable Interface
IVistaDBTable Members

Send Feedback