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? asked 19 Sep '12, 05:10 OBR Daz Liquid |
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... answered 19 Sep '12, 05:46 Volker Barth |