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.