Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Which components manage deadlocks in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is performance tuning db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Is ibm db2 free?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is db2 and what is the use of db2 optimizer?
What is the role of union all and union
is it compulsory commitment control in journal?
How to find schema of a table in db2?
What is ibm db2 used for?
What is dbrm? When it will be created?
What is a Foreign Key?
What are the 2 sqlcodes that are returned?
