Schema Object Viewer
To display information about a table or a view by expanding the Data Sources node in the navigation tree. Locate the table or view by expanding the schema where the object resides. Double-click the table or view to display it.
The table or view is displayed in a tabbed pane with the following tabs:
- Structure Tab: This tab is displayed when the object is selected in the navigation pane. It displays a comment describing the view or table (if there is one) and, in a grid, information about each attribute in the table or view. The following information is displayed for each attribute:
- PK: A check mark indicates that the attribute is a primary key; an X indicates that the attribute is not a primary key.
- Name: The name of the attribute.
- Type: The datatype of the attribute.
- Size: The length of the attribute.
- Scale: The scale for the attribute (numeric attributes only).
- Allow NULLS: A check mark indicates that the attribute can be
NULL
; an X indicates that the attribute cannot be NULL
.
- Data: This tab displays, by default, the first 100 rows of data. You control the display of rows as follows:
- To change the number of rows displayed, change Fetch size and click Refresh.
- To display the next set of rows, click Fetch Next.
- To refresh the display, click Refresh.
Copyright © 2006, 2008, Oracle. All rights
reserved.