Interested to Buy Any Domain ? << Click Here >> for more details...
can we drop column from a table
- 7 Answers
- 20766 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 u retrieve the data from null values using applicaion program.
What is coalesce in db2?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
wht are the restrictions for union ?
What is db2?
How do you stop a db2 database in linux?
What are the uses of db2 optimizer?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What are the advantages of using a PACKAGE?
Give the COBOL definition of a VARCHAR field.
What r the comman abends in db2, jcl and cobol???????
COBOL 
