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.
CREATE FULLTEXT INDEX ON MySchema.MyTable(Column1) KEY INDEX ui_identity_column;
"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
ALTER FULLTEXT INDEX
DROP FULLTEXT INDEX
GRANT Object permissions
Equivalent Oracle commands:
Oracle Text / InterMedia / ConText