CREATE FULLTEXT INDEX

Create a full-text index on a table. One full-text index with one or more columns is allowed per table.

Syntax
      CREATE FULLTEXT INDEX ON table
         [(column [TYPE COLUMN type_column_name] [LANGUAGE language_term]
             [,...n])]
               KEY INDEX index
                  [ON fulltext_catalog]
                     [WITH CHANGE_TRACKING tracking_option]

tracking_option:
       MANUAL
       AUTO
       OFF [, NO POPULATION]

Key:
    type_column_name  The column in table that holds the document type of column.
    language_term     The locale identifier (LCID)
	 index             The unique key index on table
    fulltext_catalog  The full-text catalog, must already exist.
    CHANGE_TRACKING   Maintain a list of changes to the indexed data. 

Example

CREATE FULLTEXT INDEX ON MySchema.MyTable(Column1) KEY INDEX ui_identity_column;
GO

"The greatest Christmas gift can't be purchased in a store, ordered from a catalog, wrapped in a pretty package with a fancy bow ... but it can be seen in the eyes of a child, heard in the words of kindness & felt in the embrace of a friend" ~ anon

Related commands:

ALTER FULLTEXT INDEX
DROP FULLTEXT INDEX
GRANT Object permissions
Equivalent Oracle commands: Oracle Text / InterMedia / ConText


© Copyright SS64.com 1999-2014
Some rights reserved