System Views Missing in SSMS When Using Devart Connector as a Linked Server

System Views Missing in SSMS When Using Devart Connector as a Linked Server

When using the Devart ODBC driver as a linked server in SQL Server Management Studio (SSMS), you might encounter a situation where the System Views section appears but contains no visible data.


How to Access Metadata

The necessary metadata can still be obtained by querying the internal views exposed by the Devart driver:
  1. SYS_TABLES – Lists available tables and their parameters
  2. SYS_COLUMNS – Lists table columns, their data types, and positions
  3. SYS_TABLE_CONSTRAINTS – Lists constraints, their types, and associated tables
  4. SYS_REFERENTIAL_CONSTRAINTS – Contains details on foreign keys
Example

To retrieve a list of columns for the Account table, use the following query:

SELECT * 
FROM OPENQUERY([LinkedServerName], 
  'SELECT * FROM SYS_COLUMNS WHERE Table_Name = ''account''')

Replace [LinkedServerName] with the actual name of your linked server.

    • Related Articles

    • dbForge SQL Tools Missing After Installing or Updating SSMS

      When launching SQL Server Management Studio (SSMS) for the first time after installing dbForge SQL Tools, a brief initialization process is expected. This typically takes 1–2 minutes depending on system performance. If the tools—such as SQL ...

    • How to Connect to MySQL Server

      In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

    • How to Enable Logging for SSMS Add-ins Without Built-in Logging

      Logging is essential for diagnosing complex issues and capturing technical details that may not be immediately visible through the user interface. When troubleshooting failures or unexpected behavior in SSMS add-ins that do not provide built-in ...

    • Setting up a Connection to ODBC in Delphi Using Devart ODBC Driver

      This guide will walk you through the steps of setting up a connection to an ODBC driver in Delphi. We'll use ODBC Driver for Salesforce as an example. Prerequisites: Devart ODBC Driver for Salesforce installed on your machine. A Salesforce account ...

    • CPU Metrics Not Displayed in dbForge Monitor for SQL Server

      Symptoms When using dbForge Monitor for SQL Server, you may observe that CPU metrics are not displayed for certain active connections. For instance, the CPU usage section might be empty or missing data, as illustrated in the example below: The ...