can we drop column from a table

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does runstats do in db2?

607


How to get the ddl of a table in db2?

679


How many databases are there?

594


What happens in bind step in a db2 program?

569


What are the benefits of using the db2 database?

662






When do you specify the isolation level?

612


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

716


What is temporal table in db2?

605


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

654


How do I delete a table in db2?

651


What is the difference between spufi and qmf?

641


How do you select a row using indexes in db2?

647


How do I delete a column in db2?

680


What action db2 takes when a program aborts in the middle of a transaction?

659


Explain the benefits you can get from mainframe connect?

522