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 Enhanced Full-Text Search engine.

**Table A-1: System procedures**
Procedure	Description
sp_check_text_index	Reports or fixes consistency problems in Enhanced Full-Text Search index and source tables.
sp_clean_text_events	Removes processed entries from the text_events table.
sp_clean_text_indexes	Removes text indexes that are not associated with a table.
sp_create_text_index	Creates an external text index.
sp_drop_text_index	Drops text indexes.
sp_help_text_index	Displays text indexes.
sp_optimize_text_index	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	Displays or modifies clustering options.
sp_text_configure	Displays or modifies Enhanced Full-Text Search engine configuration parameters.
sp_text_dump_database	Makes a backup copy of the text indexes in a database and optionally dumps the text_db and current databases.
sp_text_kill	Terminates all connections to a specific text index.
sp_text_load_index	Restores text indexes from a backup.
sp_text_notify	Notifies the Enhanced Full-Text Search engine that the text_events table has been modified.
sp_text_online	Makes a database available to Adaptive Server.