Tuesday, 9 April 2019

Table Description(Table properties, field properties, key properties)


A table consists out of table data and a table description. In the table description, you define what type of table this will be, which data it will contain and how it will behave.


Therefore, you need to look at the table properties and the table triggers, which are both available at the table level. In the table properties you can configure the behavior for this table, while in the table triggers, you need to write code that will be executed at certain moments.

A table description also includes fields that define which kind of data this table can hold. A field also has properties and triggers. And then finally the table description also includes information about the keys for your table. A key is necessary to create unique records, but also to define how you can sort your data.



Click on the image to see the Table properties in detail

Click on the image to see the Field properties in detail


Click on the image to see the Key properties in detail