Metadata Discovery

This section describes how to discover metadata using the linked server, through either information schema queries or SQL Server Management Studio navigation.

Information Schema Queries

SQL Server provides an information schema that you can query to view SQL Server metadata (such as lists of tables, columns, etc.) on your linked server.

To retrieve a list of tables in use on your linked server or metadata information about the columns/fields on your linked server, use OpenQuery syntax. For example:

SELECT * FROM OPENQUERY([CDATA GOOGLESHEETS], 'SELECT * FROM sys_tables'):

SSMS Navigation

You can also view metadata information on the linked server via SQL Server Management Studio's Object Explorer.

To view the tables that are available through the linked server, navigate to the Object Explorer and open Server Objects > Linked Servers > YourLinkedServerName > Catalogs > YourCatalogName > Tables.