While creating a table, by mistake you have given size of one field as 10. But

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?

Question Posted / shaikdada

4 Answers
11170 Views
CTS, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

While creating a table, by mistake you have given size of one field as 10. But as per requirement ..

Answer / 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

While creating a table, by mistake you have given size of one field as 10. But as per requirement ..

Answer / 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

While creating a table, by mistake you have given size of one field as 10. But as per requirement ..

Answer / naidu sekhar yandrapu

once enter into column length ,we can increase the data length if a table is empty but if the table is non empty we can only
increase the(data length)

in this situation add one more column should be size is 8.

Is This Answer Correct ?

5 Yes

6 No

While creating a table, by mistake you have given size of one field as 10. But as per requirement ..

Answer / 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