Choosing to edit a table from the Tables page directs you to the Columns page, which displays a list of columns in the selected table. You may create a new column by clicking the "Create new column" link at the top of the page.
The list of columns displays the following information:
Property
Description
Key
Indicates that the column is the primary key in the table
ID
Indicates that the column is an auto-incrementing identifier
Name
The name of the column
Data Type
The data type for the column
Size
The size (in bytes) of the column
Nulls
Indicates that the column allows null values
Default
The default value for the column
You can also edit or delete a column from this page by clicking the appropriate links. Note that columns are only editable if the table itself contains no data. That is, you can redesign an existing table only if it is empty.
