Answer Posted / nitesh
yes we can drop any column
ALTER TABLE <TABLENAME> DROP COLUMN <COLUMNNAME>
e.g ALTER TABLE EMP DROP COLUMN NAME
Is This Answer Correct ? | 20 Yes | 36 No |
Post New Answer View All Answers
What are types of indexes?
Which component is used to execute the sql statements?
How to run db2 command in windows?
What is a db2 collection?
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 ?
How does coalesce work?
What is a cursor in programming?
Is db2 a programming language?
What is the maximum number of columns in a db2 table?
What is the difference between spufi and qmf?
What is performance tuning db2?
What is the difference between drop table and delete table?
What is db2 connect?
What does sqlcabc has?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time