Personal tools
You are here: Home → DB2 → DB2 UDB v9 → DB2 9.7 → How to rename columns on DB2 9.7
Navigation
Log in


Forgot your password?
 
Document Actions

How to rename columns on DB2 9.7

using the ALTER TABLE statement

The RENAME COLUMN clause is a new option on the ALTER TABLE statement. You can now rename an existing column in a base table to a new name without losing stored data

 

ALTER TABLE <tabname> RENAME COLUMN <column_name> TO <new_column_name>
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls