Altering table structure
You can alter the structure of a table you have created. You can add, delete (drop), or rename a column, or change its attributes.
To alter a column:
- Click the Change button for the column you want to alter. To select more than one column, check the check boxes next to the columns you want to work with and then click the Change button to the right of the With Selected label. To select all columns, click the Check All link and then click the Change button to the right of the With Selected label.
- Edit the attributes as desired.
- Click Save.
To delete a column:
- Click the Drop button for the column you want to delete. To delete more than one column, check the check boxes next to the columns you want to delete and then click the Delete button to the right of the With Selected label.
- At the prompt, click OK to confirm deletion.
Note: You cannot delete all columns from a table (because you cannot have a table without columns.)
