Re: Find out which table columns are included
- From: "Jack" <cawoodm@xxxxxxxxx>
- Date: 15 May 2006 08:07:13 -0700
Hi Alan
I usually enable fulltext indexing on a table with the following
template:
USE MyDatabase
EXEC sp_fulltext_database 'enable'
EXEC sp_fulltext_catalog 'MyTable_Fulltext', 'create'
EXEC sp_help_fulltext_catalogs 'MyTable_Fulltext'
EXEC sp_fulltext_table 'MyTable', 'create', 'MyTable_Fulltext',
'MyTable_PK'
EXEC sp_fulltext_column 'MyTable', 'MyBinaryColumn', 'add', 0,
'MyFilenameColumn'
EXEC sp_fulltext_column 'MyTable', 'MyTextColumn1', 'add', 0
EXEC sp_fulltext_column 'MyTable', 'MyTextColumn2', 'add', 0
EXEC sp_fulltext_column 'MyTable', 'MyTextColumn3', 'add', 0
(note: google will wrap lines 5 & 6)
Using this, it's up to you to specify which columns are indexed.
Jack
.
- Follow-Ups:
- References:
- Find out which table columns are included
- From: Alan
- Find out which table columns are included
- Prev by Date: Concatenate text with the "text in row" option
- Next by Date: Re: Find out which table columns are included
- Previous by thread: Find out which table columns are included
- Next by thread: Re: Find out which table columns are included
- Index(es):
Relevant Pages
|
