SQL 6.5 ??? How to Modifying colunm properties??? 1

[FluFFy05]

I want to change a colunm ex.:<br><br>Text varchar 5 <br>to<br>Text varchar 17<br><br><br>Thanks a lot <br><br>Fluffy

 

[gummadi]

alter table a alter COLUMN a VARCHAR(3)

 

[FluFFy05]

but when I do this, I have a error message <br><br>error near word 'alter'<br>I think that it don't reconize the word 'column'<br><br>I think that this solution run only under MS/SQL 7<br><br>Thanks FluFFy

 

[jnicho02]

I seem to remember that it is not possible to change a column in 6.5. You can only add a column that allows nulls as this won't physically change the data held (you are adding null values).<br><br>In 7.0 then gummadi is right that you should do a....<br><FONT FACE=monospace>ALTER TABLE theTableName<br>&nbsp;&nbsp;&nbsp;&nbsp;ALTER COLUMN theColumnName<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR(17)</font> <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br>

 

[cdukes]

Jnicho02 is correct, <br>you cannot modify a column in SQL 6.5. The only way to do it would be to create a new table with the new definition, copy the data to the new table and then drop the old table.<br>You can then rename the new table to the same name as the original table.<br><br><br>Chris Dukes