Dropping a Column from DB2 Table

kutty.r · New User Joined: 22 Jun 2006 Posts: 24

Hi All,

I need to remove a column from the database table .I am am trying to execute the below mentioned query and ending with an error
SQLSTATE :42601

ALTER TABLE D$TEST.ETEGTTTT DROP COLUMN TTTT_DROP;

Note: could you please suggest any other query for removing a column from DB2 tables?

Thanks!

vini_srcna · Posted: Mon Aug 04, 2008 4:13 pm

Drop the table and recreate it without that column. Make sure the you unload the data before dropping it. You can later load the data.

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

vini_srcna · Posted: Tue Aug 05, 2008 1:27 pm

Sri,

You have got it right.!. I would do

1. Unload the data into a file without that column. In the SQL query I would not give the column name that needs to be dropped. This way we dont need to reformat the data.
2. Drop the table and recreate it.
3. Load the data.

vini_srcna · Posted: Tue Aug 05, 2008 1:28 pm

Ofcourse there are very good tools that they do all this process by themselves. All you have to do is to issue few commands.

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

vini_srcna · Posted: Tue Aug 05, 2008 3:56 pm

You are welcome.