Skip Navigation

123 Reg - data admin

Creating Columns

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.