Interested to Buy Any Domain ? << Click Here >> for more details...
can we drop column from a table
- 7 Answers
- 20873 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 do you eliminate duplicate values in db2?
What is sqlcode -922 ?
What is the purpose of the DSNC transaction ?
what is Static and dynamic linking
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What is a db2 cursor?
Can we install 2 different versions of Db2 on same mainframe?
How are write I/Os from the buffer pool executed?
What is index in db2?
what is dynamic cursor?gives syntax for this?
What is a clustering index?
COBOL 
