sp_remote_columns(
@server_name
, @table_name
[, @table_owner
[, @table_qualifier ] ]
)

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. 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.

None

None

• Remote data access
• Server classes for remote data access
• CREATE SERVER statement

The following example returns information about the columns in the ULProduct table in the remote SQL Anywhere database server named RemoteSA. The table owner is DBA.

CALL sp_remote_columns( 'RemoteSA', 'ULProduct', 'DBA', null );

The following example returns information about the columns in the SYSOBJECTS table in the Adaptive Server Enterprise database Production using the remote server named RemoteASE. The table owner is unspecified.

CALL sp_remote_columns( 'RemoteASE', 'sysobjects', null, 'Production' );

The following example returns formation about the columns in the Customers table in the Microsoft Access database c:\users\me\documents\MyAccesDB.accdb using the remote server MyAccessDB. The Access database does not have a table owner so NULL is specified.

CALL sp_remote_columns( 'MyAccessDB', 'Customers', null, 'c:\\users\\me\\documents\\MyAccesDB.accdb' );