Common

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.