Appendix A: System Procedures

This appendix describes the Sybase -supplied system procedures used for updating and getting reports from system tables. Table A-1 lists the system procedures included with the Full-Text Search engine.

**Table A-1: System procedures**
Procedure	Description
sp_check_text_index	Reports or fixes consistency problems in FTS index and source tables.
sp_clean_text_events	Removes processed entries from the text_events table.
sp_clean_text_indexes	Removes text indexes which are note associated with a table.
sp_create_text_index	Creates an external text index.
sp_drop_text_index	Drops text indexes.
sp_help_text_index	Enhanced version only. Displays text indexes.
sp_optimize_text_index	Enhanced version only. Runs the Verity optimization routines.
sp_redo_text_events	Changes the status of entries in the text_events table and forces re-indexing of the modified table.
sp_refresh_text_index	Adds an entry to the text_events table reflecting updates to the corresponding source table.
sp_show_text_online	Displays information about databases or indexes that are currently online.
sp_text_cluster	Enhanced version only. Displays or modifies clustering options.
sp_text_configure	Enhanced version only. Displays or modifies Full-Text Search engine configuration parameters.
sp_text_dump_database	Enhanced version only. Makes a backup copy of the text indexes in a database and optionally dumps the text_db and current databases.
sp_text_kill	Enhanced version only. Terminates all connections to a specific text index.
sp_text_load_index	Enhanced version only. Restores text indexes from a backup.
sp_text_notify	Notifies the Full-Text Search engine that the text_events table has been modified.
sp_text_online	Makes a database available to Adaptive Server.