How to find linked server table structure using T-SQL – SQL Server

The following sp_columns_ex stored procedure used to return the linked server table structure details.

EXEC sp_columns_ex ‘linkedserver_Name’, ‘table_name’, ‘Schema_name’
EXEC sp_columns_ex ‘prod_lnk’, ’employee’, ‘Humaresources’