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:
- SYS_TABLES – Lists available tables and their parameters
- SYS_COLUMNS – Lists table columns, their data types, and positions
- SYS_TABLE_CONSTRAINTS – Lists constraints, their types, and associated tables
- 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
Typically, upon the initial launch of SSMS after you install SQL Tools for the first time, there is a brief registration process that takes no more than 1-2 minutes, depending on your system's performance. If SQL Tools are still missing after this ...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 ...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 ...Error when creating a Linked Server with ODBC Drivers: "The specified DSN contains an architecture mismatch"
The error "The specified DSN contains an architecture mismatch" occurs due to a difference in architecture between the ODBC driver and SQL Server. To ensure proper operation of the Linked Server, the ODBC driver must be installed on the same machine ...Error opening table in linked server with Objects Explorer:
contains nocolumns that can be selected or the current user does not havepermissions on that object. Reply The message "contains no columns that can be selectedor the current user does not have permissions on that object" indicatesthat the query to ...