If you are entering a CREATE EXISTING TABLE statement and you are specifying a column list, it may be helpful to get a list of the columns that are available on a remote table. The sp_remote_columns system procedure produces a list of the columns on a remote table and a description of those data types.
See”List the columns on a remote table” in SQL Anywhere Server - SQL Usage.
For more information, see sp_remote_columns system procedure in the Reference: Building Blocks, Tables, and Procedures.
