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

what is diffrence b/w file-aid tool and file-aid utility???

4888

What is the meaning concurrency in the db2 database?

1108

How can you find out the # of rows updated after an update statement?

1109

What is access path in db2?

982

What is meant by explain?

1125

What is the advantage in De-normalizing tables in DB2?

1168

Define db2 and its databases?

1054

What is the difference between nvl and coalesce?

1059

What is db2 bind process?

1236

Is db2 free?

1092

How can the duplicate values be eliminated from db2 select?

1100

Which components manage deadlocks in db2?

1064

What is declare cursor?

1113

How can record locking be achieved in those DB2 versions which do not support it?

1073

Can one database have multiple instances?

1052