a problem for auditors. One way to capture what happened is to have a Repository
table that is a Column Delete Log. This can be a simple copy of the Column table.
The metadata for deleted columns can be added to the log just before being deleted
from the Column table. The log can have extra columns for the date and time of
deletion, the user who performed the deletion, and perhaps even a reason for the
deletion.
Dealing with Database Administrators
Generally speaking, database administrators do not like modifications to database
structures that do not follow predefined change control procedures. Such change
control procedures vary from organization to organization and frequently include
steps that appear to add no value to the management and integrity ...