467,146 Members | 1,021 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,146 developers. It's quick & easy.

How to change a column name.

Hi all:

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

Thanks .

Your friends.
Nov 12 '05 #1
  • viewed: 8598
Share:
1 Reply

"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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by ibm_97@yahoo.com | last post: by
3 posts views Thread by ymcj | last post: by
3 posts views Thread by kjqua | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.