The Referenced Table view lists all the tables or views that are referenced by the procedural object that you are debugging. When you debug a procedural object and execution is suspended, the Referenced Tables view opens automatically in the Database Debug perspective. From the Referenced Tables view, you can view, sort, and filter data in tables and views referenced in the procedural object, and edit table data.
In one panel, the Referenced Tables view displays a tree of referenced tables and referenced views for the specified procedural object. In another panel, the Referenced Tables view displays table or view data by row.
The Referenced Tables view supports:
Base tables or views referenced in the procedural object
Adaptive Server Enterprise sharable and nonsharable temporary tables referenced in the procedural object in the current session
| Task | Allowed for tables | Allowed for views |
|---|---|---|
| View table data | Yes | Yes |
| Enter a select statement to filter or sort the data displayed | Yes | Yes |
| Refresh the table from the database | Yes | Yes |
| Edit table data | Yes | No |
| Insert, update, or delete data rows displayed in the Referenced Tables view | Yes | No |
| Set data cell to null | Yes | No |
| Revert changes to table data | Yes | No |
| Commit table data changes to the database | Yes | No |
For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com