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’

How to find table structure using T-SQL.

Use Database_name

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = ‘Table_name’