cancel
Showing results for 
Search instead for 
Did you mean: 

Altering a remote table

Former Member
2,491

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?

View Entire Topic
VolkerBarth
Contributor

This seems to be a current restriction.

I guess you will have to either

  • do what you have suggested yourself or
  • alter the table from the remote side and then use drop table/create existing table on the local server.

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...