sp_remote_columns system procedure

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

server_name Use this CHAR(128) parameter to specify a string containing the server name as specified by the CREATE SERVER statement.
table_name Use this CHAR(128) parameter to specify the name of the remote table.
table_owner Use this optional CHAR(128) parameter to specify the owner of table_name.
table_qualifier Use this optional CHAR(128) parameter to specify the name of the database in which table_name is located.

Column name	Data type	Description
database	CHAR(128)	The database name.
owner	CHAR(128)	The database owner name.
table_name	CHAR(128)	The table name.
column_name	CHAR(128)	The name of a column.
domain_id	SMALLINT	An INTEGER which indicates the data type of the column.
width	INTEGER	The meaning of this column depends on the data type. For character types width represents the number of characters.
scale	SMALLINT	The meaning of this column depends on the data type. For NUMERIC data types scale is the number of digits after the decimal point.
nullable	SMALLINT	If NULL column values are allowed, the value is 1. Otherwise the value is 0.
base_type_str	CHAR(4096)	The annotated type string representing the physical type of the column.

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.

Sybase Supported by Open Client/Open Server.

None

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.

CALL sp_remote_columns( 'asetest', 'sysobjects', null, 'production' );

sp_remote_columns system procedure

Syntax

Arguments

Result set

Remarks

Standards and compatibility

Permissions

Side effects

See also

Example