Viewing all possible columns of an SQL database table can be useful when defining an SQL connection. By retrieving the columns of a table you can see which data you can use in the mapping table you are creating.
To be able to view the columns of an SQL database table the following requirements apply:
- A primary key must have been defined for the database table. The table needs 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 table of which you want to view the columns, including referenced tables.
To get an overview of all columns that are available in an SQL database table, click the
Next, a connection is made with the SQL database, and the columns of the selected table are retrieved.
The result is shown in the SQL table columns window, which is similar to that of a ServiceNow connection.