ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
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.
sp_remote_columns servername, tablename [, owner ] [, database]
None
None
Server Classes for Remote Data Access
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.
Sybase Supported by Open Client/Open Server.
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