Schema Diagram

[maryc]

Hi,

Can I get a Schema diagram for the ServiceNow DB?

Thanks

[coryseering · Accepted solution]

Hi Mary,

There isn't a tool in ServiceNow that, by default, can export the entire database schema. It's possible to get information about all of the fields for a table, and to get relationships between tables, pretty easily. We have an interactive, visual schema map built-in:

https://wiki.servicenow.com/index.php?title=Schema_Map_for_Tables

That link, as well as information about how to see all the tables in the system or all of the fields on a given table, is provided on the Table Administration page in the wiki:

https://wiki.servicenow.com/index.php?title=Table_Administration

GlideRecord abstracts the underlying tables and columns; there may not be a physical table for each logical table in the system, it's possible for two logical fields to be contained within the same column in a physical table, and so on. This is abstracted so that the UI and scripts accessing data don't need to be concerned with the actual DB schema.

It's very rare for the entire DB schema to actually be needed. What is your use-case? Perhaps we can figure out an easy way to get exactly the information you need.

[TroySasso]

Hi Guys,

Is there a reliable third party tool that acts as a graphical, interactive Schema map for ServiceNow?

Thanks

[Matt211]

This is the only thing I've found which might meet some of your criteria: https://demo.erm4sn.com/

I've not tried the full product, I just remembered I had bookmarked this when I read your post.