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

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