A script-enabled browser is required for this page to function properly.

Data source object notation in the Query window (Query Builder)

Shown below is an example of two tables in the Query window's Data Source panel, linked by a relationship.

Click any icon, indicator, or part of these objects to display a description:

example of two tables in the Query window Data Source panel

Object type indicator

The icon in the upper left corner of any data source object indicates its type:

the Table icon Table

the View icon View

the Query icon Query

the Snapshot icon Snapshot

the Synonym icon Synonym

Object title

This is the name of the data source object. You can change the name by clicking on the object title.

Comment indicator

This icon indicates that this object (or column) has a comment associated with it. Double-click this icon to open the Info dialog box, where you can view the comments.

Primary key

A column name displayed in boldface indicates that this column has been defined as a primary key for the object.

Datatype indicators

The following icons indicate the datatypes of their respective columns.

The icons that indicate all the datatypes

If you click and hold on one of these icons, a pop-up menu appears, and you can choose a different datatype.

 

 

Column Name

This is the name of one of the columns in this object. If you double-click a column name, the column will be included in your query.

Foreign key

A column name displayed in italics indicates that this column is a foreign key, related to a primary key in another column. Setting up a relationship between two columns is the only way to define a foreign key. 

Self-relationship indicator

This icon indicates that a self-relationship has been created between this column (foreign key) and another column (primary key) in the same table.

Relationship line

A gray line drawn between two columns indicates that a relationship has been created between the columns at either end of the line. The line is drawn from the foreign key to the primary key.

See also

About Query Builder datatypes

Datatype icons (Query Builder)

About Query Builder relationships