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

[Dan Bertuleit]

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.)

[Jan Spurlin · Accepted solution]

@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.
2. • 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.
4. • 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...

[Chetan21]

Regarding your point about how to find all tables for a particular application –

Go to System Definitions => Tables, in the list record see if the column “Application” is visible if not personalize the list to include “Application” column. Once visible simply filter the list by application you are interested in. for e.g

 

To explore the schema of  interested table, click the table label and open the details forms, go to related – “ Show Schema Map”

 

[Dan Bertuleit]

Sachin, Jan, and Chetansing:  Thank you for your replies.  Very helpful.   Dan

[vamsee_l]

A nice enhancement would be to show the schema map just for all the tables in a given scoped application. There doesn't seem to be any way to do that right now. 

[D_ Barre]

Agree 100%. Most of the time, that's what we are in need of.