Sql语句建立全文索引

—给YSZJ_CP数据库的ScreenInvestor_ACT_Son表建立全文索引

use 数据库
go
execute sp_fulltext_database 'enable'

—启动创建全文索引

—判断唯一索引键是否存在，存在的话删除

if (SELECT INDEXPROPERTY( OBJECT_ID('ScreenInvestor_ACT_Son'), 'PK_ScreenInvestor_ACT_Son', 'IsFulltextKey'))=1
begin
--print '1'
DROP FULLTEXT INDEX ON ScreenInvestor_ACT_Son
end

—判断全文索引键是否存在，存在的话删除

if (SELECT FULLTEXTCATALOGPROPERTY('Act_son', 'accentsensitivity')) is not null
begin
--print '1'
DROP FULLTEXT CATALOG Act_son
END

—声明全文索引键

execute sp_fulltext_catalog 'Act_son','create'
execute sp_fulltext_table 'ScreenInvestor_ACT_Son','create','Act_son','PK_ScreenInvestor_ACT_Son'

—将唯一索引和全文索引进行绑定声明
—插入该表的全文索引目录

execute sp_fulltext_column 'ScreenInvestor_ACT_Son','Abbreviation','add'
execute sp_fulltext_column 'ScreenInvestor_ACT_Son','ACT','add'
execute sp_fulltext_column 'ScreenInvestor_ACT_Son','Agenda','add'
execute sp_fulltext_column 'ScreenInvestor_ACT_Son','CreditCode','add'
execute sp_fulltext_column 'ScreenInvestor_ACT_Son','FoundationName','add'
execute sp_fulltext_column 'ScreenInvestor_ACT_Son','Genre','add'
execute sp_fulltext_column 'ScreenInvestor_ACT_Son','ProvincialLevel','add'
execute sp_fulltext_column 'ScreenInvestor_ACT_Son','SourceTable','add'

—激活全文索引目录

execute sp_fulltext_table 'ScreenInvestor_ACT_Son','activate'

—填充该表的全文索引

execute sp_fulltext_catalog 'Act_son','start_full'