Displays all of the properties of the fields and indexes contained in the current table.
Some of the properties are read-write. If they are read-only, they are not accessible by the mouse or keyboard.
Use this dialog box to create, view, and modify table structures.
Some of the dialog items are self-explanatory and the others are described below:
Table Name
Displays the name of the table.
Field List
Displays a list of the fields.
Name
Allows you to type the name of the field you want to add.
Type
Lets you determine the operational or data type of the field.
Size
Lets you determine the maximum size, in bytes, of the field.
FixedLength
If selected, allows you to have a field with a fixed size.
VariableLength
If selected, allows you to have a field whose length you can adjust.
AutoIncrement
If selected, automatically updates the next row or column.
AllowZeroLength
Allows you to have a zero-length string as a valid setting.
Required
Indicates if the field requires a non-Null value.
OrdinalPosition
Allows you to determine the relative position of the field.
ValidationText
Lets you add the text of the message that your application displays if a user tries to enter an invalid value for a field.
ValidationRule
Lets you determine what data is valid in a field as it is added.
DefaultValue
Lets you determine the default value for the field.
Add Field
Displays the Add Field dialog box.
Remove Field
Removes the selected field (Only available with Jet database engine Tables).
Index List
Lists the available indexes.
Name
Allows you to type the name of the index.
Primary
If selected, indicates this is the primary index for the table.
Unique
If selected, indicates that the index entry is unique.
Foreign
If checked, indicates that the index represents a foreign key in the table.
IgnoreNulls
If selected, indicates that fields with Null values are not included in the index.
Required
Indicates whether the index requires a non-Null value.
Add Index
Displays the Add Index dialog box.
Remove Index
Removes the selected index.
Build the Table
Appends the new table to the current database.
Print Structure
Prints the table structure (not available on new TableDef objects).