Table Wizard - Set Types and Formats

рдЖрдкрдХреЗ рдЪрдпрдирд┐рдд рдХреНрд╖реЗрддреНрд░ рдХреЗ рд▓рд┐рдП рдХреНрд╖реЗрддреНрд░ рдЬрд╛рдирдХрд╛рд░реА рдирд┐рд░реНрдзрд╛рд░рд┐рдд рдХрд░рддрд╛ рд╣реИ.

рдЪреБрдиреЗ рдЧрдП рдХреНрд╖реЗрддреНрд░

Select a field in order to edit the field information.

^

Click to move the selected field up one entry in the list.

v

Click to move the selected field down one entry in the list.

-

Remove the selected field from the list box.

+

Add a new data field to the list box.

рдХреНрд╖реЗрддреНрд░ рдЬрд╛рдирдХрд╛рд░реА

рдХреНрд╖реЗрддреНрд░ рдирд╛рдо

Displays the name of the selected data field. If you want, you can enter a new name.

рдХреНрд╖реЗрддреНрд░ рдкреНрд░рдХрд╛рд░

Select a field type.

рд╕реНрд╡рддрдГ рдореВрд▓реНрдп

If set to Yes, the values for this data field are generated by the database engine.

рдкреНрд░рд╡рд┐рд╖реНрдЯрд┐ рд╡рд╛рдВрдЫрд┐рдд

If set to Yes, this field must not be empty.

рд▓рдореНрдмрд╛рдИ

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)

For this example, you must enter AUTO_INCREMENT into the Auto-increment statement box.

Table Wizard - Set primary key