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 Post subject:

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 · Posted: Tue Aug 05, 2008 10:35 am Post subject:

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

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 Post subject:

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 · Posted: Tue Aug 05, 2008 2:32 pm Post subject:

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

You are welcome.