How do I print, view, or export a database schema for my SNOW instance and applications?

Go to solution
Dan Bertuleit
Giga Contributor

‎06-03-2020 10:10 AM

How do I print, view, or export a database schema for my SNOW instance and applications?

I found the "Dictionary Entries" list of 99,000 + rows, but this is not at all helpful!  How does a user or developer print what is classically called the database schema?  (See James Martin's book " Computer Data-Base Organization" for definition of a schema.)

 

0 Helpfuls
  • 4,722 Views
1 ACCEPTED SOLUTION

Go to solution
Jan Spurlin
ServiceNow Employee
ServiceNow Employee
In response to Dan Bertuleit

‎06-04-2020 05:12 AM

@Dan Bertuleit - there is another way to do this from inside your instance and is more reliable.

There is a table that contains all of the components installed on your instance.  The table name is sys_metadata.  Filtering this will give you everything that is installed on your instance.  Here are the steps to see what you want for a particular scope:

  1. In the app nav filter type "sys_metadata.list"  -  without the quotes.
    • This will provide a list of all the components installed on your instance.  Tables are one of those components.
  3. This list is huge.  Filter it for the scope application you are asking about.
    • Use the filter Application | is | Z, where Z is the name of the scoped application.
  5. Then filter that list for Class | is | Table.

This will show all roles that were installed with the specific scoped application you have used in your filter.

Here is the knowledge article that discusses this:

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/plugins/task/find...

View solution in original post

10 REPLIES 10

Go to solution
AlecBrouillette
ServiceNow Employee
ServiceNow Employee
In response to vamsee_l

‎08-25-2022 12:17 PM

Added new reply to back up this request, and add export function for the diagram

0 Helpfuls