|
View previous topic :: View next topic
|
| Author |
Message |
saigiridhar_s
New User
Joined: 25 Feb 2005
Posts: 2
Location: bangalore
|
|
|
|
hi,
Iam Giridhar here is my doubt plz answer to this question and thanksa in Advance.
Q.Can we change the Data size in Db2.if we can how ew can change.Is it possible using ALTER Command?
Ex: in Table empName char(20) but ii is necessary to make is char(30),how? |
|
| Back to top |
|
 |
mcmillan
Site Admin
Joined: 18 May 2003
Posts: 1214
Location: India
|
|
|
|
| Quote: |
| Can we change the Data size in Db2 |
Yes, We can change the Data Type / Size of the column after DB2 8.0. before that it's possible to change the size of the column if it's declared as VARCHAR.
| Quote: |
| if we can how ew can change |
Using ALTER TABLE... ALTER COLUMN statement
| Quote: |
| Table empName char(20) but ii is necessary to make is char(30),how? |
ALTER TABLE EMP ATLER COLUMN EMPNAME SET DATA TYPE CHAR(30) |
|
| Back to top |
|
|
|
|
