How to change a column name.

[Marble]

Hi all:

In DB2 CLP mode ,how to change a column name expect to recreate a table?

Thanks .

Your friends.

[Rhino]

"Marble" <zx****@yahoo.com.cn> wrote in message
news:cf***********@mail.cn99.com...

Hi all:

In DB2 CLP mode ,how to change a column name expect to recreate a table?

Sorry, I don't understand the question. Do you mean that you want to rename
a column without recreating the table?

On some platforms, such as DB2 V7.2 on Windows/Unix/Linux, you can rename a
table but not a column in the table. However, it may be possible to rename a
column in other DB2 versions or platforms. Have a look at the SQL Reference
for your DB2 version and platform and take a look at the ALTER TABLE
command. If it is possible to rename a column, that is almost certainly the
command you would use.

Rhino