While many properties can be manipulated, only a few will commonly be used.
- Table type – Determines if the table is considered a regular database table or a temporary table, such as a TempDB or InMemory table.
- Name – If used in a form to display in the user interface as a page, the name is what the user will see on the page. Names and labels should use camel case for consistency, but table names will display in capital letters.
- Label – Will be added from a label file and is used to identify the table in Visual Studio.
- Primary index – Specifies which field in the table should be used as the primary index and is used for database optimization purposes.
- Cluster index – Specifies the field by which the table should be organized. This property should never be left blank.
- Configuration key – Allows a system administrator to enable and disable certain parts of the application and ensures that a table is removed when the key is disabled.
- Support inheritance – Determines whether the table can become a base table by using inheritance. Setting this property to Yes indicates that this table can be extended, or that it can inherit properties from an existing table.
- Extends – Used when the Support Inheritance property is set to Yes. The Extends property chooses the base table that will become the parent table to the current table.