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 are the rules for db2 programming?
What is plan in cobol db2?
How do I optimize a query in db2?
How to fetch the last row from the table in SQL (db2)?
What is db2 optimizer?
Is schema the same as database?
How to get the ddl of a table in db2?
Which is faster delete or truncate?
What is iseries database?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Is db2 a database?
What is dbrm?
If I have a view which is a join of two or more tables, can this view be updateable?
Highlight all the advantages that are attached to a package.
What is an instance database?
