SQL Objects (With History)

This page displays only SQL objects that have been changed.

To access this page:

  1. Click Common > Analyze in Navigation pane.
  2. Click Trace for Data Source ID.
  3. Click an applicable icon to view tracked objects.
  4. Click the Filter Changed Only icon.
Field Description
OBJECT NAME Displays name of object being traced.
TYPE_DESC Displays type of SQL object, e.g., table, view, procedure.
ADDED ON Displays date object was added to the database.
DELETED If enabled, the object existed in the database, but was deleted.
SQL Click to view the original SQL code that was captured when object was registered.
CHANGED ON Displays date and time when the object was modified.
History Click to view an audit trail of the object’s SQL code.