Schema view in Table Builder

Use Schema view in Table Builder to explore data relationships for your application data.

Avant de commencer

• 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.

Procédure

1. Navigate to the Data tab.
   Remarque :

   Spreadsheet view displays by default.
2. Facultatif : Select Schema from the additional actions menu () to access Schema view.
3. Navigate through the schema diagram by dragging the canvas with your mouse.
4. You can perform the following additional actions on this read-only screen.

   Option	Description
   Navigation overview controls	Select the 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. Select the Zoom in icon () to zoom in. Select the Zoom out icon ( ) to zoom out.
   Show / hide table fields	The Expand tables 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 Expand tables to toggle it off.
   Show / hide tables	Use the Items selected 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.
   Set field options	Use the Field options menu to control how fields display in the schema diagram. Select Extended fields to display extended fields within schema tables. Select Field type to show the type of field for each field displayed in the 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 () 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.
   View in Table Builder	Select the View Table icon () to view the selected table in Table Builder.