Altering a remote table

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?

remote-server

asked 19 Sep '12, 05:10

OBR
291●10●11●22
accept rate: 0%

retagged 24 Sep '12, 07:38

Daz Liquid
905●20●25●41

flat view

One Answer:

active answers oldest answers newest answers popular answers

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

permanent link

answered 19 Sep '12, 05:46

Volker Barth
40.5k●365●556●827
accept rate: 34%

edited 19 Sep '12, 05:52

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

remote-server ×56

question asked: 19 Sep '12, 05:10

question was seen: 2,255 times

last updated: 24 Sep '12, 07:38

SAP SQL Anywhere

Altering a remote table

Follow this question

Related questions