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's gravatar image

OBR
291101122
accept rate: 0%

retagged 24 Sep '12, 07:38

Daz%20Liquid's gravatar image

Daz Liquid
905202541


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%20Barth's gravatar image

Volker Barth
39.9k360547816
accept rate: 34%

edited 19 Sep '12, 05:52

Your answer
toggle preview

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

Question tags:

×56

question asked: 19 Sep '12, 05:10

question was seen: 2,033 times

last updated: 24 Sep '12, 07:38