It depends on DB2 version. In DB2 V9 we can drop a column. In DB2 V8 we c

can we drop column from a table

Question Posted / prem

Answer Posted / prem

It depends on DB2 version.
In DB2 V9 we can drop a column.
In DB2 V8 we cant.

Is This Answer Correct ?

12 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Outputs of explain are with matchcols = 0. What does this signify?

810

Can there be more than one cursor open for any program?

885

How to rename a table in DB2 ?

798

On which levels locks can be applied?

836

How is the value function used?

807

What is temporal table in db2?

785

How to restart a DB2 program?

1558

Mention the downsides of page level lock.

904

How to compare data between two tables in db2?

824

What is innodb buffer pool?

728

How do I create a view in db2?

772

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1936

What is db2 look?

762

What is the role of union all and union

837

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2627