Note: See Properties Panel for an overview of how this tool works.
When a table item is selected in Table Explorer or Table Editor, the attributes for that item are displayed in the Properties Panel. Four types of attributes are displayed:
Table Attributes – A table attribute applies to the entire table.
Column Attributes – A column attribute applies to a single selected column within the table.
Index Attributes – An index attribute applies to a single selected index within the table.
Index Segment Attributes – An index segment attribute applies to a single selected index segment for a single index within the table.
The selected item determines which kind of attribute is displayed. For example, selecting the table node in Table Explorer will display table attributes for the selected table while selecting a table’s column node will display the column attributes for the selected column.
The names of the attributes are listed in the left column and their values are listed in the right column. See Database API Attributes for more about the API attributes. Pressing the F1 help key will locate the attribute help topic for any the selected property row.
Different databases and drivers support different attributes. Only the attributes that are appropriate for the selected database/driver are displayed.
Attributes can only be edited if the selected table is actually opened for editing in Table Editor. Most table editing is done within Table Editor. Only the less used attributes need to be edited directly in the Properties Panel. For example, you can define a table as being a system table by setting the DF_FILE_IS_SYSTEM_FILE attribute to True in the Properties Panel. Although you could change name of a column with the Property Panel it is much easier to do this within Table Editor.
Many of the attributes are read-only.
If Table Editor is defined as being read only within a workspace, attribute editing will also be disabled in the Properties Panel.