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.
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.
If you were to run this query in your application, these names would come across.
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.
These alias names will now be displayed when you run the query and also in your application.
Add an Alias
Prerequisite
Tables and fields have been selected for the query.- Type an alias name in the Alias field.
View the Alias Name
- Click the Run button in the Table and Fields app bar.
tip
Your, query, query fields, and form need to be saved.