Metadata Discovery
This section describes how to discover metadata using the linked server. You can do so either through information schema queries or SQL Server Management Studio navigation.
Information Schema Queries
The information schema is a method SQL Server provides for obtaining metadata. You can query this schema to view SQL Server metadata, including lists of tables, columns, etc. on your linked server. INFORMATION_SCHEMA is the schema name used in SQL queries.Below are examples of information schema queries:
Table Query
This query returns a list of tables in use on your linked server:SELECT * FROM [Linked Server Name].[CData OneDrive Sys].[INFORMATION_SCHEMA].[tables]
Columns Query
This query returns metadata information about the columns/fields on your linked server:SELECT * FROM [Linked Server Name].[CData OneDrive Sys].[INFORMATION_SCHEMA].[columns]