Create and Manage a Full Text Index

Create and Manage a Full Text Index

Each SQL Server 2005 and SQL Server 2008 database on all web hosting plans allow for full text indexes.

To enable full-text indexing for the current database:

exec sp_fulltext_database 'enable'

To create a full text catalog:
exec sp_fulltext_catalog 'catalogname', 'create'

To enable indexing of a table:

exec sp_fulltext_table 'tablename', 'create',
'catalogname', 'indexname'

To add a column to an index:
exec sp_fulltext_column 'tablename', 'columnname', 'add'

To activate fulltext on a table:
exec sp_fulltext_table 'tablename', 'activate'

Add Feedback