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 the responsibility of the construction superintendent
What is package in db2 mainframe?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is a collection in db2?
What is table space in db2?
How to execute stored procedures?
What is the syntax for seeing the columns and data types of a table in the db2 database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
When reorg is used?
What's The Percentage Free Space ?
What is db2 bind?
What is iseries database?
What is db2 stogroup?
Explain db2.
How to test SQL -911 error while developing COB-DB2 program
