Zend Studio allows you to view data stored in a database table. The contents of the database table are displayed in table form in the Data Display area of the SQL view.
Studio's procedure for viewing the contents of a database table is an assisted query of the SQL database. When you select a table from the SQL tab's database tree, Studio executes an SQL query that returns the contents of the table. How much of the table data you see in the Data Display depends on the display parameters you define.
SQL Data Display
Functions, Shortcuts and the Right-click Menu
Right clicking on any of the tree elements in the SQL file tree opens a menu of functions that include:
|
|
Refresh - Refreshes the SQL tree display. The refreshed elements are the ones that lie inside the refreshed node. |
|
|
Query - Displays the SQL query editor. |
|
|
Metadata - Displays the selected element's metadata. |
|
|
Table Data - Displays the contents of a table. |
|
|
Global Settings - Displays the Studio preferences for the SQL tool. |
|
|
|
|
|
Related Links: Data Display: Large Number of Results |
|
|
|
