Relationship of tables in Service Now

[Alberto Ch_vez]

Please.... How can I identify the relationship of the tables in a Project?, and if any changes are made, find out which tables would be affected?.

For your attention. Thank you

[johansec]

You can look at the tables and see if there are any reference fields ( somewhat like a foreign key ).

Also the table sys_relationship defines relationships between tables

[Alberto Ch_vez]

How could you perform a system cloning? Have in a private repository and edit it in another instance, so that the changes that are made, do not affect the original. (Somewhat like a test center). Thank you

[Robert Webb1 · Accepted solution]

Hello Alberto Chávez,

You can find this information by looking at the schema map of the table. The schema map displays the details of tables and their relationships in a visual manner, allowing administrators to view and easily access different parts of the database schema. I have also provided some information on system cloning below.

Navigate to schema map:

1. In the navigation bar find the "tables" module under system definition.
2. Open the record for the table in question
3. In the related links section at the bottom choose "Show Scheme map"

System cloning:

The system clone application allows users with the clone_admin or admin role to clone data from one instance to another.

This functionality is primarily used to clone a production instance over an existing sub-production instance before developing or testing changes. All clones are performed using the most recent nightly backup.

Additional Information:

Schema map for tables

System clone

Hope this helps!