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

    • SQL Complete tabs (SSMS)

      You may change settings for your tabs layout using these settings: In case you need to create custom tab names, please use this tab: You may find more information with tutorials in our documentation: ...

    • dbForge SQL Tools Missing After Installing or Updating SSMS

      If dbForge SQL Tools Are Missing After Installing or Updating SQL Server Management Studio (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 ...

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

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