View text index terms and settings in Interactive SQL.
To view settings and statistical information about a text index, you must have one of the following system privileges:
To view terms for a text index, you must also have one of the following privileges:
The text index must be initialized.
Connect to the database.
Run the sa_text_index_stats system procedure to view statistical information about a text index:
CALL sa_text_index_stats( );
Run the sa_text_index_vocab system procedure to view terms for a text index:
CALL sa_text_index_vocab( );
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|