To add a column to the table, choose the "Alter" option from the "Select" list. Select the "Add" option from the "Alter" list, then select "Column" from the next list. Enter the new column name in the "Column Name" textbox and select the column type from the "Column Type" drop-down menu. Specify the location of the new column in the table by clicking one of the "Insert Column" radio buttons. If you click "After" radio button, you have to select a column from the "Column Name" list.
First: will insert the new column before the first existing column.
Last: will insert the new column after the last existing column.
After: will insert the new column after the column selected from the "Column Name" menu.
Choose the data type for the column from the drop-down menu. Assign the attributes for the selected data type by clicking the appropriate check boxes next to the data type drop-down menu. You can enter the maximum length of data for the column in the "length" textbox. Enter the default value for the column in the "Default" textbox if necessary. Click the "Build SQL Query" button. After reviewing the SQL Query click the "Run SQL Query" button to complete the operation. The result of operation will appear at the bottom of the page.