General information
Category:
Coding, syntax & commands
ALTER TABLE myTable ALTER column myField C(3)
>Good day everyone,
>I want to change the field size of a table with code but can't figure out how to get the syntax correct. The field width is currently 6 and I want to make it 3 and it's of Character type. I'm using Fox Pro 6 by the way. The help for Alter Table states:
>
>ALTER TABLE TableName1
> ADD | ALTER [COLUMN] FieldName1
> FieldType [(nFieldWidth [, nPrecision])]
>
>So I use the following code to test it and I get a syntax error:
>ALTER TABLE myTable ALTER [16] myField C [(3)]
>
>Please help!
>Thanks!
>Max
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only