Alter table



IBM's flagship relational database management system

Alter table

Postby madhavan » Tue Mar 27, 2012 4:06 pm

Hi,

I am create one table. In this table have 4 columns as name, fname, city, zipcode, phoneno.
i am successfully create the table. But i need to drop a column but it not drop it has show some error.

ALTER TABLE CARD DROP COLUMN CITY

It has show the following error msg.
SQL error at or before (line 6, position 23).
Pls any one help me :(
Thanks in advance.
Regards,
Madhavan
madhavan
 
Posts: 23
Joined: Fri Mar 09, 2012 11:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: Alter table

 

Re: Alter table

Postby enrico-sorichetti » Tue Mar 27, 2012 5:24 pm

why don ' You look at the manual for the DB2 version You are using to check if the DROP clause is allowed ???
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Alter table

Postby madhavan » Tue Mar 27, 2012 6:10 pm

hi,

i was seen that but it wont work. i have worked on the QMF.
Pls help me to alter a particular column and drop a particular column.

Regards,
madhavan
madhavan
 
Posts: 23
Joined: Fri Mar 09, 2012 11:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: Alter table

Postby Akatsukami » Tue Mar 27, 2012 8:09 pm

madhavan wrote:i was seen that but it wont work. i have worked on the QMF.

This is incomprehensible. If you are unable to communicate clearly, there is no place for you in IT.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post