This option allows you to change the name, type and attributes of an existing column. You can use this option for renaming the column without having to create a new column and losing the data as a result.
Note that when you want to rename a column, you still need to set the data type and attribute fields for the query return your desired result.
To change a column, choose the "Alter" from the "Select" list. Select the "Change" option from the "Alter" list. Choose the column you want to make changes to from the "change Column Name" list . Enter the new name in the "to new Column Name" textbox . Choose the new attributes for the column.
After making the necessary changes click the "Build SQL Query" button and 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.