Interested to Buy Any Domain ? << Click Here >> for more details...
can we drop column from a table
- 7 Answers
- 21084 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 |
What is the difference between Primary key and unique index?
What is db2 isolation?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
How to get Top 10 Salaries from a Table
Can we declare DB2 HOST variable in COBOL COPY book?
What is an access path?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
Name the lockable units in DB2?
How to compare data between two tables in db2?
What is a db2 table?
how do u update the faltfile into db2 table ?
How is the SUBSTR keyword used in sql?
COBOL 
