sp_remote_columns System Procedure

Produces a list of the columns in 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 [, @table_owner ] [, @table_qualifier ]] )