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: 1210 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 |
|
|
|