View Objects
The SQL code for the following object types is tracked for any given data sources:
- Tables
- Procedures
- Views
- Functions
- Other – additional SQL objects, such as synonyms, triggers and table functions
To view objects:
-
Click Analyze in Navigation pane.
NOTE: The Analyze page displays data source registered in System Administration. Data sources are analyzed for database object changes, table statistics and duplicate records.
-
Click Trace for Data Source ID.
-
Click an applicable icon to view tracked objects.
Two icons are available:
- Click SQL icon to view the original SQL code, which is captured at the time an object is registered.
- Click History icon to view an audit trail of the object.
NOTE: If the database is refreshed and a change has been made to the object, the audit trail of the modified SQL code is recorded. Refer to View Object History for detailed information.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.