 |
 |
Archives of the TeradataForum
Message Posted: Wed, 07 Dec 2005 @ 13:45:37 GMT
| Subj: | | Re: ALTER table to change column width |
| |
| From: | | Victor Sokovin |
| | 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. | |
The most flexible solution is probably to use the ALTER TABLE command to:
1. create the new column;
2. if necessary, move the data from the old column to the new one (this task is, obviously, outside of the ALTER TABLE
possibilities);
3. drop the old table;
4. rename the new column to the old name.
Regards,
Victor
| |
