ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sp_remote_columns system procedure

Function 

Produces a list of the columns on 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 [, owner ] [, database]

Permissions 

None

Side effects 

None

See also 

Accessing Remote Data

Server Classes for Remote Data Access

CREATE SERVER statement

Description 

If you are entering a CREATE EXISTING 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. sp_remote_columns produces a list of the columns on a remote table and a description of their data types. If you specify a database, you must either specify an owner or provide the value null.

Standards and compatibility 

• Sybase    Supported by Open Client/Open Server.

Example 

• The following example returns columns from the sysobjects table in the production database on an Adaptive Server Enterprise server named asetest. The owner is unspecified.

  sp_remote_columns asetest, sysobjects,
  null, production