In Adaptive Server version 12.5.2 and later, primary keys can be used as the text id column. You can create text indexes on tables that contain an identity column or a suitable primary key. Primary keys defined on a single decimal, numeric, int, smallint, or tinyint column are also eligible. Decimal and numeric columns must have a scale of zero
When creating a text index, EFTS first looks for an IDENTITY column in the source table to use as the ID column of the text index. If an IDENTITY column is not found, EFTS looks for a suitable primary key that it can use as the ID column of the text index.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
