The modify option is the same as change except that it does not allow you to change the column name. You can change the attributes of a column using the modify option.
To modify a column, choose "Alter" from the "Select" list. Select the "Modify" option from the "Alter" list. Choose the column you want to make changes to from the "change Column Name" list . Set the desired attributes for the column and click the "Build SQL Query" button. After reviewing the SQL query click the "Run SQL Query" button to complete the operation. The result of the operation will be displayed at the bottom of the page.