can we drop column from a table
- 7 Answers
- 18003 Views
- INDUS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srini
We can not drop a column. If we want we can append colume
with ALTER command.
| Is This Answer Correct ? | 30 Yes | 9 No |
Answer / prem
It depends on DB2 version.
In DB2 V9 we can drop a column.
In DB2 V8 we cant.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / kumar
It is not possible directly. Indirectly we could do it.
Create a view by eliminating the column (th one to be
deleted). Drop the table or create a new table. Copy from
the view to the newly created table. Pl correct if I'm
wrong.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / 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 |
Answer / zoheb ali ahmed
Drops only take place at, minimum, table level.
| Is This Answer Correct ? | 0 Yes | 13 No |
Answer / 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 |
Can any one tell me about Restart logic in DB2.
What is a result table?
How will fetch last 5 rows from table in db2
What is database manager in db2?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
Is ibm db2 open source?
What is the cascade rule and how does it relate to deletions made with a subselect?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
Where would you find information about the type of database authority held by the user?
What does the CHECK Utility do ?
what is the difference between normal select query and currosor
COBOL 
