3. Using the Tables Utility : Get Information about Tables and Views
 
Share this page                  
Get Information about Tables and Views
Use the Examine operation on the Tables Catalog frame to display information about a table, synonym, view, or index.
To use the Examine operation
Place the cursor over the name of the table or view you wish to learn about, and then select the Examine operation.
The Examine a Table frame is displayed:
If you are examining a synonym or view, the Rows, Storage Structure, Pages/Overflow, and Journaling fields do not appear on the frame.
If you are examining a synonym, the base table's name and schema name also display. If you do not have access to the base table, only the base table's name and schema name display.
All the fields on the Table Information frame are display‑only; you cannot edit or change any information.