Q: How do I modify a column name?

A: You can modify a column name through DBATool. Follow the steps described below:

1. Launch DBATool.

2. Choose "Object management" from the menu bar and then the "Table" item. The "Table" dialog window appears.

3. Select the database you want to modify from the "Database" combobox.

4. Select the table you want to modify from the "Table" combobox.

5. Press "+" beside "Column". The "Add/Modify" dialog window appears.

6. Modify the column name.

Alternatively, you can use dmSQL to modify a column name. Use the following syntax:

		  dmSQL> ALTER TABLE table_name MODIFY column_name NAME TO NEW_NAME;
		  

Example: modify salary column to age.

		  dmSQL> alter table t1 modify salary name to age;