创建全文索引的命令是CREATE FULLTEXT INDEX.部分语法如下所示;
CREATE FULLTEXT INDEX ON table_name
[ ( { column_name
[ TYPE COLUMN type_column_name ]
[ LANGUAGE language_term ]
} [ ,...n]
) ]
KEY INDEX index_name
[ ON fulltext_catalog_name ]
[ WITH [ ( ] <with_option> [ ,...n] [ ) ] ]
[;]
<with_option>::=
{
CHANGE_TRACKING [ = ] { MANUAL | AUTO | OFF [, NO POPULATION ] }
| STOPLIST [ = ] { OFF | SYSTEM | stoplist_name }
}
CREATE FULLTEXT INDEX参数
参 数 | 描 述 |
table_name | 这个参数指定要创建全文索引的表的名称,一个表只允许有一个全文索引 |
column_name | 这个参数定义要建立 |