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