SYSIBMTS.TSCOLLECTIONNAMES view
The SYSIBMTS.TSCOLLECTIONNAMES view displays the names of collections.
Each row represents a collection for a text search index.
| Column name | Data type | Nullable? | Description |
|---|---|---|---|
| INDSCHEMA | VARCHAR(128) | NO | Schema name of the text search index |
| INDNAME | VARCHAR(128) | NO | Unqualified name of the text search index |
| COLLECTIONNAME | VARCHAR(132) | NO | Name of the associated collection on the text search server. In partitioned database systems, each text index partition is represented as a collection. The collection name includes the partition number as suffix. |