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
- 11214 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
Is db2 a database?
What is dpf in db2?
What is the maximum number of columns in a db2 table?
What is check constraint. Explain with example.
What is the usage of open cursor command?
Which isolation level provides maximum concurrency?
What is dbrm?
How to run db2 command in windows?
What is buffer pool in the db2 database?
What language is db2 written in?
Is db2 a mainframe?
What are host variables in db2?
What is iseries database?
What is the use of reorg in db2?
Name the various locking levels available?
