You can view information about text indexes in the database using Sybase Central, or by using a SQL statement.

To view text indexes in the database (Sybase Central)

1. Connect to the database as a user with DBA authority, or as the owner of the text index.

2. In the left pane, click Text Indexes.

3. To view the terms in the text index, double-click the text index in the left pane, and then choose the Vocabulary tab in the right pane.

4. 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 choose Properties.

To view text indexes in the database (SQL)

1. Connect to the database as a user with DBA authority, or as the owner text index.

2. Call the sa_text_index_stats system procedure, as follows:

   CALL sa_text_index_stats( );

See also

• sa_text_index_stats system procedure