Common

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.