Calculated Columns

Some stencils use strings computed from other related tables ( i.e. foreign key tables). For example, in the Chinook database, the Customer table is a foreign key table to the invoice table:


So, we may want to display Customer.FirstName +", " + Customer.LastName as a calculated field in the Invoice table to enhance how some stencils are able to generate code.



  1. Column Name - This is the name of the column. Note: this column is not physically available in the table schema.
  2. Set as Table Label.
  3. Formula - This is the formula used to generate the required calculated string.
  4. Foreign Key Table - This is a grid representing the foreign key table with all the available columns listed.


Was this article helpful?