Asked on behalf of TimSki37: Is it possible to recover or restore database constraints in a schema/library that has been cleared and restored from a different schema/library?
We have a library that was cleared of all physical files and tables were restored from a different library. In doing so, however, all constraints were lost and the system/cross-reference tables were corrupted. As a result of the corrupt cross-reference tables, the system also no longer allows for the addition of constraints on these tables.
What steps must occur so that the contraints can be recovered if that is even possible?