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 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 open the Table Data editor to 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 |
| Open the Table Data editor | Yes | - |
| Insert, update, or delete data rows displayed in the Referenced Tables view, using the Table Data editor | Yes | - |
| Set data cell to Null in Table Data editor | Yes | - |
| Revert changes in Table Data editor | Yes | - |
| Commit Table Data editor changes to the database | Yes | - |
Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com
Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.