sp_remote_columns system procedure

Function

Produces a list of the columns in a remote table, and a description of their data types. The server must be defined with the CREATE SERVER statement to use this system procedure.

Syntax

sp_remote_columns ( @servername , @tablename [, @table_owner ] [, @table_qualifier ]] )

See "sa_verify_password system procedure" in SQL Anywhere Server – SQL Reference.

See also

Chapter 5, “Server Classes for Remote Data Access” and Chapter 4, “Accessing Remote Data” in the System Administration Guide: Volume 2

CREATE SERVER statement in Reference: Statements and Options