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 / rahul
If table is empty then we alter this column to any length,
but if some data got inserted into the table then we can
also decrease the column length upto largest data size
available in that perticulat column.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is explain in db2?
Define db2 and its databases?
What is dbrm library?
What is the difference between plan and package in db2?
Is the primary key a clustered index?
what is a corelated subquerry?
What is with ur in db2?
What is the meaning concurrency in the db2 database?
Where do you specify them?
How to rename a table in DB2 ?
What does db2 stand for?
How do you find the maximum value in a column in db2?
What is data manager?
Is db2 a mainframe?
Explain in detail about buffer manager and its functionalities?