sp_clean_text_indexes

Description

Removes indexes from the vesaux table that are not associated with a table.

Syntax

sp_clean_text_indexes

Parameters

None.

Examples

Example 1

sp_clean_text_indexes

Usage

This procedure reads entries from the vesaux and vesauxcol tables, verifying that both the source table and the corresponding index table exist. If either is missing, the index is dropped.

Messages

Fetch resulted in an error
Unable to drop object definition for index_name!

Permissions

Any user can execute sp_clean_text_indexes.