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
What is db2 purescale?
What are foreign keys in db2?
What is a buffer in memory?
What is the difference between drop table and delete table?
What is the function of logging in the db2 database?
Explain the contents that are a part of dclgen.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
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.
Mention the definition of cobol in varchar field.
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is dbrm? When it will be created?
How do I delete a table in db2?
What is access path in db2?
What is a bind in db2?
What is concurrency?
