To append data in proxy table.

[former_member245994]

Hello Everyone,

I want to append new data in proxy table which already have some data into it. How we can do this? Is is possible to do so?
What is difference between proxy table and create existing proxy table? Can you please provide any document or video link to know more about create existing proxy table?

Any help will be appreciated!

[former_member188958]

What do you mean by "append new data"? You can add additional characters to char and varchar column values using UPDATE; you can add new rows to the table using INSERT. In general, you use a proxy table the same ways you would use a local table.

The main difference between the two commands is that CREATE EXISTING TABLE requires you to provide the definition of the column names and datatypes, while CREATE PROXY_TABLE looks them up for you. CREATE EXISTING TABLE predates CREATE PROXY_TABLE and generally isn't used anymore, but is kept around for backward compatibility.