Answer Posted / rbs
yes we can drop, but column should not have any data.
eg: ALTER TABLE <TB NAME> DROP COLUMN Col-name.
Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
What is meant by explain?
What is a page in db2?
How is deadlock resolved?
Differentiate between cs and rr isolation levels? Where do you specify them?
Are views updateable?
Which component is responsible for db2 startup and shutdown?
Is ibm db2 free?
What is dpf in db2?
How can we retrieve the total number of records in RPG & CLLE?
What is the difference between db2 and oracle?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the role of the data page in the db2 database?
What is table space in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is coalesce in db2?