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. |
|
|
|