Alias Names

Last updated 11/04/2022

Aliases in Five

Aliases are used to give a temporary name to a column in a table. They're frequently used to make column names easier to read. The alias name will only exist for the duration of that query.

Five prefixes the name of a column with it's table name for clarity of which table the field belongs to. You can create an alias for the column to display how you would like the field to be viewed.

Example

Four fields are selected from a table and no alias has been set.

Figure 1 - Fields with no aliases

When we run the query you can see Five prefixed the table name to the field name to avoid ambiguity. The field names are also displayed how they are written in the database.

Figure 2 - Column names

If you were to run this query in your application, these names would come across.

Figure 3 - Column names in an application

By setting an alias, you will temporarily give the field name a new name that will be used in replacement of the real field name. This alias name will be carried through to your application.

Figure 4 - Set alias names

These alias names will now be displayed when you run the query and also in your application.

Figure 5 - Alias column names

Add an Alias

Prerequisite

Tables and fields have been selected for the query.

1. Type an alias name in the Alias field.

Figure 6 - Add an alias name

View the Alias Name

1. Click the Run button in the Table and Fields app bar.

Figure 7 - View alias name

tip

Your, query, query fields, and form need to be saved.