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
- 11479 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / mr.perfect
IF field is having empty in table , then we can reduce or
increase the size of the field, using the alter statement .
i.e . alter table <tablename>
modify <new columnname ><data type><new size>
if the data in the table is non-empyt, then we cannot alter
the table. better to delete the column and add the same
column to new size.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is a storage group (stogroup)?
What is collection in db2 bind?
What is with ur in db2?
Comment whether the cursor is closed during commit or not.
How do you concatenate the firstname and lastname from emp table to give a complete name?
Which is faster delete or truncate?
What do you mean by rollback?
What is the default page size of buffer pools?
Explain about open switch business continuity software?
Why do we use cursor?
How many types of page locks can be held in db2?
How can you quickly find out the # of rows updated after an update statement?
What is the physical storage length of the data types date, time, and timestamp?
List out the three types of page locks that can be held.
what is a corelated subquerry?
