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 does db2 stand for?
What does a deadlock mean in DB2?
What is cobol db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What parameters are used to control the free space in DB2?
How do I optimize a query in db2?
What is the max length of sqlca?
What is the role of union all and union
What is the use of value function?
What does db2 mean?
When the like statement is used?
Explain correlated sub-queries.
How many types of page locks can be held in db2?
What is db2 instance?
Mention data types used in db2 ?