List the Columns 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.

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.

SeeSQL Anywhere Server - SQL Usage > Remote data and bulk operations > Accessing remote data > Working with proxy tables > List the columns on a remote table.

Note: This reference points to SQL Anywhere documentation.

For more information, see Reference: Building Blocks, Tables, and Procedures > System Procedures > System Stored Procedures > Catalog Stored Procedures > sp_remote_columns System Procedure.