ap_hso_get_dropobjects_sp

This procedure returns all objects where the last row in abahistsysobjects says isdeleted = 1, but the object still exists in the database. Normally,this is an anomaly but it's a perfectly normal condition during DBBUILD -restruct, and DBBUILD -restruct uses this procedure to get all objects to drop at the end of execution.

 

Current the result set includes four columns:

objname - The name of the object.

objtype - The object type.

parent - The parent table for objects like triggers, indexes etc.

cmd - The command to drop the object.

 

The procedure takes no parameters.