Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain in brief how does db2 determine what lock-size to use?
What is the physical storage length of the data types date, time, and timestamp?
Explain correlated sub-queries.
What is the meaning concurrency in the db2 database?
What is the use of with ur in db2?
Which component is responsible for processing sql statements and selecting access paths?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
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?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How to execute stored procedures?
How can the duplicate values be eliminated from db2 select?
What is reorg and runstats in db2?
Why cursor is used in db2?
What is the max length of sqlca?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
