Viewing text index terms and settings (Sybase Central)

View text index terms and settings in Sybase Central.

Prérequis

To view complete information about a text index, you must be the owner of the table or materialized view or have one of the following system privileges:

CREATE ANY INDEX
CREATE ANY OBJECT
ALTER ANY INDEX
ALTER ANY OBJECT
DROP ANY INDEX
DROP ANY OBJECT
MANAGE ANY STATISTICS

To view information in the Vocabulary tab, you must also have one of the following privileges:

SELECT privilege on the table or materialized view on which the text index is built
SELECT ANY TABLE system privilege

The text index must be initialized.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, click Text Indexes.
To view the terms in the text index, double-click the text index in the left pane, and then click the Vocabulary tab in the right pane.
To view the text index settings, such as the refresh type or the text configuration object that the index refers to, right-click the text index and click Properties.

Résultat

The text index terms and settings are displayed.

Viewing text index terms and settings (Sybase Central)

Task

See also