Step 1. Verifing that the text_events table exists  Step 3. Creating a unique index on the IDENTITY column

Chapter 3: Configuring Adaptive Server for Full-Text Searches

Step 2. Checking for an IDENTITY column or primary key

Every source table must contain an IDENTITY column or primary key, which uniquely identifies each row and provides a means of joining the index table and the source table.

For example, to add an IDENTITY column to the reviews table, enter:

alter table reviews add id numeric(10,0) identity

See “Adding an IDENTITY column to a source table” for more information.




Copyright © 2005. Sybase Inc. All rights reserved. Step 3. Creating a unique index on the IDENTITY column

View this book as PDF