View previous topic :: View next topic
|
Author |
Message |
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
I have table i want to delete column in the table then i want to add new column also in the same table.can i perform those operations on the column? |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
In case you meant a DB2 Table in your question. Its better to unload the table first and create a new table with altered attributes and load new table with requisites. |
|
Back to top |
|
|
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
Thanks for your reply , but what i am asking here can perform add and Delete operations on COLUMN in DB2 table? |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
babu,
Column can't be dropped off however you can add another column in a Table. And you use "ALTER TABLE" statement for the same.
Go thru this link to get syntax on how to use this statement. |
|
Back to top |
|
|
|