By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

How to change a column name.

P: n/a
Hi all:

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

Thanks .

Your friends.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"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.