To get an overview of all SQL tables that are currently available in your SQL database, you can view them.
To be able to view SQL database tables the following requirements apply:
- A primary key must have been defined for the database tables. The tables need a column for identification.
- You have read access to at least the following database tables, depending on the database type you are working with:
- IBM DB2: syscat_tables and syscat.columns (only tested for Windows, Linux is unknown)
- SQL Server or MySQL: information_schema.tables and information_schema.columns
- You have read access to the database tables you want to view, including referenced tables.
In the connection view, select the connection, and then click
Next, a connection is made with the SQL database, and the tables are retrieved.
The result is shown in the SQL tables window, which is similar to that of a ServiceNow connection.