on 2012 Sep 19 6:10 AM
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.