SQL Objects

Use this page to View Objects.

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.
Field Description
Filter Changed Only Click to apply the filter to only display changed objects.
Filter All Click to remove change filter so all objects display.
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 original SQL code that was captured when object was registered.
CHANGED ON Displays date and time when object was modified.
History Click to open the History of Changes page to view an audit trail of object’s SQL code.