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?
- 4 Answers
- 9581 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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 buffer pool in the db2 database?
What is the use of value function?
How is a typical db2 batch pgm executed?
What is the role of schema in the db2 database?
What is db2 bind?
How to find schema of a table in db2?
How does coalesce work?
What is null indicator in db2?
What is null in db2?
What is phantom read in db2?
What is database manager in db2?
What is a page in db2?
What is role in db2?
What's The Error Code For Unique Index Voilation?
What is a plan and package in db2?
