Interested to Buy Any Domain ? << Click Here >> for more details...
can we drop column from a table
- 7 Answers
- 20860 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 |
How can you do the explain of a dynamic sql statement?
What are the three types of page locks that can be held?
How many buffer pools are there in DB2?
What is table space in db2?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is sqlca’s maximum length?
What is ibm db2 used for?
How do you pull up a query which was previously saved in qmf?
what are bind concepts in db2 cobol?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
COBOL 
