The source table contains the data on which you perform searches (for example, the blurbs table in the pubs2 database). For more information, see “The source table”.
Before you can create text indexes on a source table, you must:
Verify that the source table has an IDENTITY column or primary key. If not, alter the table and add an IDENTITY column.
Create a unique index on the primary key or IDENTITY column (optional).
Every source table must contain an IDENTITY column or primary key to uniquely identify each row and provide a means of joining the index table and the source table. When you create a text index, the IDENTITY column or primary key is passed with the indexed columns to the Enhanced Full-Text Search engine. The IDENTITY column or primary key value is stored in the text index and is mapped to the id column in the index table. If a table does not have a primary key an IDENTITY column can be added to the table.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
