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,719 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
sachin_namjoshi
Kilo Patron
Kilo Patron

‎06-03-2020 10:26 AM

Follow below to view schema map

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/table-administrat...

 

Regards,

Sachin

0 Helpfuls

Go to solution
Dan Bertuleit
Giga Contributor

‎06-03-2020 10:51 AM

Thanks, this helps.  Is more power available?  The tips require knowing which table is of interest, selecting it, and viewing the schema.  What if I want to see all of the tables supporting one of the applications?  For example, all of the tables added with and / or used by in the Advanced Risk application?

Also, I have been searching the developer's site for basic training in this sort of general knowledge.  Is there a training module that focuses on general knowledge, like this topic?  

0 Helpfuls

Go to solution
sachin_namjoshi
Kilo Patron
Kilo Patron
In response to Dan Bertuleit

‎06-03-2020 11:00 AM

You can get list of all tables installed with any application on documentation site e.g Advanced Risk application

You can go to https://docs.servicenow.com and search like "tables installed with advanced risk" and you will see below kind of search results

https://docs.servicenow.com/bundle/orlando-governance-risk-compliance/page/product/grc-risk/referenc...

 

Regards,

Sachin