While creating a table, by mistake you have given size of one
field as 10. But as per requirement size should be 8. What is
your next step?
Answer Posted / hameed shaik
In Db29 we can alter the column size but cannot delete the column..
I did it so many times.. ALTER TABLE Tablename ALTER COLUMN columnname SET DATA TYPE VARCHAR(51)
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the role of the data page in the db2 database?
Is ibm db2 free?
What is dbrm library?
what is diffrence b/w file-aid tool and file-aid utility???
What is a trigger in the db2 database?
How do I import a csv file into db2?
What does db2 mean?
What are db2 objects?
What are the bind parameters ibm db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the advantage in De-normalizing tables in DB2?
What is a db2 schema?
What is commit in db2?
How do I add a column in db2?
What's The Error Code For Unique Index Voilation?