The sp_remote_columns system procedure produces a list of the columns on a remote table and a description of those data types.
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.
For more information, see Reference: Building Blocks, Tables, and Procedures > System Procedures > System Stored Procedures > Catalog Stored Procedures > sp_remote_columns System Procedure.