Contents Index sp_login_environment system procedure sp_remote_exported_keys system procedure

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 servernametablename [, 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 
Example 

Contents Index sp_login_environment system procedure sp_remote_exported_keys system procedure