Tools → Schema Designer → Joins

About the Schema Designer Joins tab

The Joins tab shows all join relationships related to the physical schema objects, whether they are self-join, schema join, or cross-schema join relationships.

The Joins tab includes the following:

• Action bar: includes multiple options to search and sort the join relationship list
• Join list header:
  • Child: the left side of the join including the physical schema, if shown, the object, and the join column
  • Hide/Show Schema Name: to hide or show the physical schema name in the join’s Child side
  • Parent: the right side of the join including the physical schema, the object, and the join column
  • +: to add a new join relationship
• Join conditions: the condition(s) of each join relationship. Each condition consists of three parts: the Child side of the join, the join operator, and the Parent side of the join. The color of each row indicates whether the join relationship is between objects in the same physical schema or between objects in different physical schemas.
• More Options (⋮ vertical ellipsis): this menu is available when the Child object in the join is in the current physical schema. The menu contains the following options:
  • Join Details: to access the Join Editor to view or manage the join conditions and filters
  • Remove Join: to remove the join relationship

Schema Designer actions for a join relationship

Using the Schema Designer, you can perform the following actions for join relationships:

• Create a join relationship
• View join relationship properties
• Edit a join relationship
• Remove a join relationship
• Search and filter the join list
• Sort the join list
• Preview the physical schema join diagram

Create a join relationship

• In the Navigation bar, select Schema.
• In the list view of schemas, select a given physical schema.
• In the Schema Designer, do one of the following:
  • In the Joins tab, select + (Add New Join).
  • In the Action bar, Select + New → Join.
• In the Join Editor, for the new join relationship, specify the join properties for the Child and Parent sides.
• In the Join Editor, select Done.

View join relationship properties

• In the Schema Designer, in the Joins tab, for a given join relationship, do one of the following:
  • Select the join relationship.
  • Select More Options (⋮ vertical ellipsis), and then select Join Details.
• In the Join Editor, review the join conditions and filters, if any.
• To exit the Join Editor without saving updates, if any, select Cancel.

Edit a join relationship

• In the Schema Designer, in the Joins tab, for a given join relationship, do one of the following:
  • Select the join relationship.
  • Select More Options (⋮ vertical ellipsis), and then select Join Details.
• In the Join Editor, make the necessary updates.
• To save updates, in the Join Editor, select Done.

Remove a join relationship

• In the Schema Designer, in the Joins tab, for a given join relationship, select More Options (⋮ vertical ellipsis), and then select Remove Join.
• In the dialog, select Delete.

Search and filter the join list

You can search for join relationships and filter them by defining a search term and specifying the part of the join you want to search in. The search term can be part of the object name or the join column name, and it is not case-sensitive. For example, when you enter “sales” in the search box and select to search in As Child, the list is filtered to show all join relationships that have “sales”, “SALES”, “Sales”, and the like in the object or column name in the Child side of the join.

Here are the steps to search and filter the join relationship list.

• In the Schema Designer, in the Joins tab, select the All Joins box, and then select the suitable option in which you want to search for the search term. The following are the available options.
  • All Joins: to show the join relationships that have the search term in any side of the join regardless of the join type
  • As Child: to show the join relationships that have the search term in the Child side of the join
  • As Parent: to show the join relationships that have the search term in the Parent side of the join
  • With Filter: to show only join relationships that have one or more filters and have the search term in any side of the join
  • Self-join: to show only self-join relationships that have the search term in any side of the join
• In Search for any join, enter a search term that can be part of the object or column name.

Sort the join list

You can sort the join list in ascending or descending order. By default, the join list is sorted in ascending order by the different parts of the Child side. When more than one join relationship has a common schema name, the object name is used to sort by, and when they share the same object name, the column name is used to sort by. If more than one join relationship shares the Child side, parts of the Parent part are used to sort by.

Here are the steps to sort the join relationship list.

• In the Schema Designer, in the Joins tab, select the arrow to point downwards to sort in descending order, or select it again to point upwards to sort in ascending order.
• Select the side you want to sort by: Child Table or Parent Table.

Preview the physical schema join diagram

• In the Navigation bar, select Schema.
• In the list view of schemas, select a given physical schema.
• In the Schema Designer, in the Summary section, select the Diagram View icon.
• In the Schema Diagram Viewer, review the physical schema join relationships.