ServiceNow Schema Tables

ServiceNow stores data in structures which do not follow the rules of data typing and structure that apply to traditional relational tables and columns. Because traditional ODBC toolsets might not support these data structures, the data needs to be mapped to a relational form. To achieve this, the Simba ServiceNow ODBC Connector uses schema tables to map the ServiceNow data to an ODBC-compatible format.

The schema tables are listed alphabetically by table name. For each table, the following information is provided:

• The name of the table.
• Whether the table is a virtual table, and if so, the table that it is contained in.
• Whether the table contains any virtual tables, and if so, which ones.
• Any of the columns in the table that are foldable, that is, whether operations on those columns can be delegated to the server instead of the client.
• A list of all of the columns in the table, with information about the SQL type and whether the column is nullable, updatable, or returnable by ODBC-escaped DML statements.

Each ServiceNow database table is exposed through two schemas: Actual and Display. The Actual schema returns the raw data values that are stored in the ServiceNow database. The Display schema returns more human-readable representations of those values, as data of type String. Typically, the values from the Display schema are shown in the ServiceNow user interface.