If a table is selected in the left pane of the navigation window, the right pane will contain description of structure of this table – a list of its fields (figure 23-2).
Figure 23-2. Description of table fields
List pane caption contains column names. Columns “Name” and “Type” contain the name and type of the field accordingly. The columns “Indexed”, “Unique”, “Not empty” and “Encrypted” contain information about attributes of each field. The presence of the sign “+” means that the appropriate attribute is set.
The following commands can be applied to the selected field:
Edit+Add – allows the user to determine the new table field. When this command is performed a dialog box “Adding field” will be opened.
Edit+Rename – permits changing the name of selected field;
Edit+Remove – removes the selected field. Before removing the system asks for confirmation.
Edit+Order – enables the user to change the order of fields in the table. The order of fields in the list pane of the navigation window determines the sequence in which fields in table browsing will be displayed and also the sequence of locating input fields in the windows of adding and editing records. The order of fields in description of table structure can be changed for the created and filled in table as well.
Edit+Properties allows for change of attributes of the selected field. After performing this command the system will open a property sheet “Properties of field”.
All the changes of table structure are immediately saved in GDB.
If a table is selected in a pane of the navigation window, at the menu command Edit+Properties a property sheet “Properties of table” will be opened. On page “General” of the property sheet the name of the table and number of records are displayed, on the page “Permissions” – permissions of the current user to the table are given (see chapter 87 “Permissions to GDB and its components”).
