Table Wizard - Set Type Formatting
Specifies the field information for your selected fields.
પસંદિત ક્ષેત્રો
Select a field in order to edit the field information.
-
Remove the selected field from the list box.
+
Add a new data field to the list box.
Field information
ક્ષેત્ર નામ
Displays the name of the selected data field. If you want, you can enter a new name.
ક્ષેત્ર પ્રકાર
Select a field type.
AutoValue
If set to Yes, the values for this data field are generated by the database engine.
Entry required
If set to Yes, this field must not be empty.
Length
Specifies the number of characters for the data field.
દશાંશ જગ્યાઓ
Specifies the number of decimal places for the data field. This option is only available for numerical or decimal data fields.
મૂળભૂત કિંમત
Specifies the default value for a Yes/No field.
Auto-increment statement
Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field. For example, the following MySQL statement used the AUTO_INCREMENT statement to increase the "id" field each time the statement creates a data field:
CREATE TABLE "table1" ("id" INTEGER AUTO_INCREMENT)
In other words, enter AUTO_INCREMENT into Auto-increment statement box.