I have myTable with MyColumn VARCHAR(50)
I need to change the length of this field to 100
I tried
ALTER TABLE myTable ALTER COLUMN myColumn VARCHAR(100);
but that generated an error. So I tried
ALTER TABLE myTable CHANGE myColumn myColumn VARCHAR(100);
but that generated the same error.
I can drop the column and recreate it, but I'm wondering what the correct syntax is.
Thanks to all..........Rich
UPDATE.......the second command worked. I had not editted the original command correctly in the viewer.