Example: enabling a new database for text searches  Step 2. Checking for an IDENTITY column or primary key

Chapter 3: Configuring Adaptive Server for Full-Text Searches

Step 1. Verifing that the text_events table exists

Each database containing tables referenced by a text index must contain a text_events table, which logs inserts, updates, and deletes to indexed columns.

If a text_events table is in your model database, it will be in all new databases. If a text_events table is not in your model database, run the installevent script to install the text_events table in the new database. For example, to install the text_events table in the movies database:

See “Running the installevent script” for information on installing the text_events table.





Copyright © 2005. Sybase Inc. All rights reserved. Step 2. Checking for an IDENTITY column or primary key

View this book as PDF