create proxy_table imports metadata from a remote server and converts column information into an internal create existing table command, with a column list derived from the imported metadata. When obtaining the column metadata, conversion from the remote DBMS type to internal Adaptive Server Enterprise types is required.
If the size of a remote char, varchar, binary, or varbinary column exceeds the maximum allowed by the local server, its length is truncated to the maximum size possible, which depends on page size. If the size exceeds 16K bytes, the type is converted from char or varchar to text, or from binary or varbinary to image.
