Returned result
1 will be returned on successful completion.
–1 will be returned if there was a warning generated during the processing. It would be acceptable to continue processing.
–2 will be returned if a handled error occurred. This would normally indicate that the calling procedure should fail, unless it is not concerned about the state of the indexes.
–3 will be returned if an unhandled error occurred.
Examples
The following examples all drop all indexes from a table called load_customer: