I'm frequently using proxy tables for existing remote tables/views. The CREATE EXISTING TABLE syntax is very convenient for that, particularly as I don't have to specify column names and types then.

However, when the remote table/view is altered lateron (say, to add a column), this change is not applied to the proxy table. Furthermore, it seems to be forbidden to use ALTER TABLE on a proxy table to add new columns "manually". As a consequence, one has to drop and recreate the proxy table (and re-assign the according permissions).

Therefore, it would by handy if there was as statement like

ALTER EXISTING TABLE MyTable

working similar to the ALTER VIEW RECOMPILE statement, i.e. it should regenerate the column definitions (and automatically drop/recreate indexes) based on the remote table.

asked 19 May '10, 09:58

Volker%20Barth's gravatar image

Volker Barth
37.6k345513778
accept rate: 34%

It's a shame that you have to specify the table in detail at all - I believe in SQLServer you just add a reference to the database and then you can use any object you have rights to.

(19 May '10, 11:09) Justin Willey

@Justin: AFAIK, that's only true when you relate to different databases on the same database server, and that's a consequence of the SQL Server/ASE "master database architecture". When relating to a different server (via MS linked server), it works similar to SA proxy tables, methinks.

(19 May '10, 11:14) Volker Barth

Just to complete: The answer from Karim Khamis [Sybase] in the product futures NG:

Good suggestion Volker. We will consider it for a future release.

Karim

permanent link

answered 25 May '10, 07:42

Volker%20Barth's gravatar image

Volker Barth
37.6k345513778
accept rate: 34%

1

Well, it's been a very old request, and just today I ran over it again...

ALTER TABLE would be handy for proxy tables particulary when privileges have to be rebuilt after the workaround via DROP TABLE/CREATE TABLE.

(15 Mar, 13:39) Volker Barth
Replies hidden

OMG it's only been eleven years since the last time someone asked for this feature! :)

(16 Mar, 16:58) Breck Carter
1

Yes, I'm still waiting for the future ;)

(17 Mar, 03:53) Volker Barth
1

I have subscribed to this thread. Let's meet in eleven years again to check the status.

(19 Mar, 08:28) Vlad
Comment Text Removed
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:

×110
×65
×54
×36

question asked: 19 May '10, 09:58

question was seen: 4,937 times

last updated: 22 Mar, 11:35