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
- 11360 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 db2? Explain.
What are the various data types available in db2?
What is a db2 schema?
What is host variable?
Why do we bind in db2?
What is a system catalog table in db2?
How do I import data from excel to db2?
Why do chiropractors use drop table?
What is performance tuning db2?
How do I import a csv file into db2?
Explain what are the various isolation levels possible?
can all users have the privilage to use the sql statement select * (dml)?
What is db2 instance?
How to execute stored procedure in db2 command editor?
How can the duplicate values be eliminated from db2 select?
