Using SQL Anywhere 12, is it possible to alter a remote table?
ALTER TABLE tablename ADD columnname decimal(12,0)
Returns : Alter remote table not implemented
Do I really need to drop and recreate the entire table when I want to add a column?
This seems to be a current restriction.
I guess you will have to either
FWIW, a while ago I had suggested an ALTER EXISTING TABLE statement - cf. this FAQ. This would not help with the first solution, but would ease the second one a little bit...