We can not drop a column. If we want we can append colume with ALTER comm

can we drop column from a table

Question Posted / srini

Answer Posted / srini

We can not drop a column. If we want we can append colume
with ALTER command.

Is This Answer Correct ?

30 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is reorg and runstats in db2?

1142

How to check last update on table in db2?

999

What are the uses of db2 optimizer?

1221

What is the reason behind not using select * in embedded sql programs?

1043

Explain the function of data manager.

988

What is cursor with hold option in db2?

1009

Give the name of some fields form sqlca.

1017

Can we insert update delete in view?

908

What is universal database?

1029

Is db2 free?

1035

Explain the benefits you can get from mainframe connect?

910

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

What's The Error Code For Unique Index Voilation?

1150

What is db2 optimizer?

1177

What is a db2 collection?

981