 |
 |
Archives of the TeradataForum
Message Posted: Wed, 07 Dec 2005 @ 16:15:44 GMT
| Subj: | | Re: ALTER table to change column width |
| |
| From: | | Praveen_Chakrapani |
Hi Samar,
| | Can I change the width of any column with the ALTER table command? (VARCHAR (10) to VARCHAR (20) as vice versa) | |
| | I didn't find any MODIFY clause for column in ALTER table command help. | |
You can alter the table using add clause itself just like this:
Create table t1(i int , v varchar(10));
Alter table t1 add v varchar(20);
Also note that you cann't decrease the size and you cann't modify PI column attributes.
Regards,
Praveen
| |
