ICMSTTextIndexes (Oracle Text Search Indexes)
The ICMSTTEXTINDEXES table contains information on text search indexes for the Oracle library server only.
| Column Name | Data Type | Attribute |
|---|---|---|
| IndexID | NUMBER(10) | NOT Null |
| IndexType | NUMBER(10) | NOT Null |
| ComponentTypeID | NUMBER(10) | NOT Null |
| ColumnName | VARCHAR2(18) | NOT Null |
| IndexName | VARCHAR2(18) | NOT Null |
| Custom1 | VARCHAR2(100) | nullable |
| Custom2 | VARCHAR2(100) | nullable |
| Flag | NUMBER(10) | nullable |
- Primary Key
- (IndexID)
- Indexes
- None.
- Referential Constraints
- None.
Column Definitions
- IndexID
- Internal identifier for the index.
- IndexType
- Type of the index. Currently, the only valid value is:
- 1 - Oracle context text index
- ComponentTypeID
- ComponentTypeID of component that the index is on.
- ColumnName
- Name of the column that the index is on.
- IndexName
- Name of the index in the text engine. This is based on the ComponentTypeID and ColumnName.
- Custom1
- Reserved for future use.
- Custom2
- Reserved for future use.
- Flags
- Used internally during index modification (to properties of the index such as preference classes, not to data).