Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11480 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
Can one database have multiple instances?
What is cobol db2?
can all users have the privilage to use the sql statement select * (dml)?
What is runstats db2?
What parameters are used to control the free space in DB2?
Explain the function done by data manager?
What is null indicator in cobol db2?
How do I change the column size in db2?
Explain about cursor stability?
What is db2 and what is the use of db2 optimizer?
What are db2 objects?
Outputs of explain are with matchcols = 0. What does this signify?
What is the maximum number of columns in a db2 table?
Differentiate between cs and rr isolation levels? Where do you specify them?
What does a deadlock mean in DB2?
