CONTENTS
  Creating
  Editing
  Deleting
  Querying
  Importing
  Exporting
  Properties
  Roles
  Creating
  Editing
  Deleting
  Querying
  Creating
  Editing
  Creating
  Editing
  Server Logins
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.