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




We wanted to inform you that the necessary information can be obtained by accessing the following internal views:

SYS_TABLES - lists available tables and their parameters
SYS_COLUMNS - lists table columns, determines to which tables they belong, their position in tables, data type and other parameters
SYS_TABLE_CONSTRAINTS - lists constraints and specifies their types and tables they belong to
SYS_REFERENTIAL_CONSTRAINTS - contains details on foreign keys

 

For example, you can get a list of columns in the Account table using the query:

SELECT * FROM OPENQUERY([LinkedServerNAme],'Select * From SYS_COLUMNS where Table_Name = ''account''')


    • Related Articles

    • 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 ...

    • Error created linked server with ODBC Drivers. "The specified DSN contains an architecture mismatch"

      Please be informed that the error "The specified DSN contains an architecture mismatch" indicates that the computing of our driver and SQL Server are different. To operate as part of Linked Server, you need to install the ODBC driver on the same ...

    • dbForge SQL Tools Missing After Installing or Updating SSMS

      Please note that dbForge SQL Tools integrate only with the version of SSMS already installed on your PC. Therefore, if you have updated or installed a new version of SSMS, we recommend the following steps: Uninstall SQL Tools: Ensure that the current ...

    • How to Install MySQL on Windows Using MySQL Installer

      The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with ...

    • Lost Connection to MySQL Server

      If you are experiencing a loss of connection to MySQL servers (applies to any server), we would like to highlight that in most cases, this issue is not related to our product (dbForge). Typically, this problem can be resolved by following the ...