Schema view in Table Builder
Use Schema view in Table Builder to explore data relationships for your application data.
Before you begin
- Launch Table Builder. For more information, see Accessing Table Builder.
- (Optional) Choose a domain to work within (if not global). For more information, see Domain separation and Table Builder.
- (Optional) Choose an application scope to work within (if not global). For more information, see Using an application scope with Table Builder.
Role required: personalize_dictionary or AES user role and delegated developer permissions. For more information, see Delegate developers using AES.
Procedure
Navigate to the Data tab.
Note: Spreadsheet view displays by default.
Select Schema from the additional actions menu (
Image omitted: tb-data-addl-actions-menu.png
Additional actions menu.\) to access Schema view.
Additional actions menu.\) to access Schema view.
Navigate through the schema diagram by dragging the canvas with your mouse.
You can perform the following additional actions on this read-only screen.
| Navigation overview controls | Select the Overview toggle icon ( Image omitted: icn-us2-schemaview-overview.png - Select the Zoom in icon ( Overview toggle icon.) in the lower right corner to toggle the navigational overview controls on or off. This navigational control enables you to perform the following actions:- When the schema diagram is zoomed in, you can drag the rectangle showing your view around by clicking and dragging it to focus it on the part of the diagram you want to review. Image omitted: icn-us2-schemaview-zin.png - Select the Zoom out icon ( Zoom in icon.) to zoom in. Image omitted: icn-us2-schemaview-zout.png - Select Field type to show the type of field for each field displayed in the schema tables.Zoom out icon.) to zoom out.</td></tr><tr><td id="d232752e210"><strong>Show / hide table fields</strong></td><td>The <strong>Expand tables</strong> toggle is toggled on by default to show all the fields within the displayed schema tables. To hide the fields within the displayed schema tables, select <strong>Expand tables</strong> to toggle it off.</td></tr><tr><td id="d232752e225"><strong>Show / hide tables</strong></td><td>Use the <strong>Items selected</strong> menu to view a list of application and non-application tables that are displayed in the schema diagram. You can select the table name to remove the selection checkmark, which hides the table from displaying in the diagram. To show the table, select the table name again to toggle the checkmark back on.</td></tr><tr><td id="d232752e237"><strong>Set field options</strong></td><td>Use the <strong>Field options</strong> menu to control how fields display in the schema diagram.- Select <strong>Extended fields</strong> to display extended fields within schema tables. |
| Group fields | Use the Group fields by menu to group fields within the displayed tables (e.g., grouping fields by type). Choose from the following grouping options:- No group - Extended - Reference - Type |
| Sort fields | Use the Sort fields menu to sort fields within the displayed tables. Choose from the following sorting options:- Alphabetically (A to Z) - Alphabetically (Z to A) |
| View legends | Select View legends to view information for interpreting the displayed schema diagram. |
| Table-specific options | Select the Additional options icon ( Image omitted: icn-us2-schemaview-addloption.png Additional options icon.) for a table to control how fields in the selected table are displayed, grouped, and/or sorted similar to the top-level options described above.</td></tr><tr><td id="d232752e340"><strong>View in Table Builder</strong></td><td>Select the <strong>View Table</strong> icon ([Omitted image "icn-us2-schemaview-navtotb.png"] Alt text: Navigate to Table Builder icon.) to view the selected table in Table Builder.</td></tr></tbody> Parent Topic:Data in Table Builder |