Hi all,
You can not drop a column in DB2..
1.Rename the table to temporary table
2.creat a new table without the column you want to drop.
3.Then insert the data from the temporary table.
4.Drop the temporary table

Hope it helps

-----Original Message-----
From: gujral_shilpa
[mailto:db2udbdba-ezmlmshield-x1580947.[Email address protected]
Sent: Tuesday, November 30, 2004 11:29 AM
To: LazyDBA Discussion
Subject: dropping a column

Hi all !!
is there some way to drop a column of a table in DB2 ?

Regards,
Shilpa Gujral.


************************************************************************
***
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privilaged
information. If you are not the intended receipient, please contact the
sender by reply e-mail and destroy all copies and the original message.
Any unauthorized review , use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on
this e-mail is strictly prohibited and may be unlawful. The recepient
acknowledges that BTVL or it's subsidaries and associated companies,
(collectively BTVL ), are unable to exercise control or ensure or
guarantee the integrity of/over the contents of the information
contained in e-mail transmissins and further acknowledges that any views
expressed in this message are those of the individual sender and no
binding nature of the message shall be implied or assumed unless the
sender does so expressly with due authority of BTVL.
Before opening any attachments please check them for vituses and
defects.
************************************************************************
****






---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------------------------------
This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message.

DB2 & UDB email list listserv db2-l LazyDBA home page