How to query and export DB Schema or Schema of a Table in ServiceNow instance?


Description

This article explains how to query DB Schema or Schema of a Table in ServiceNow instance.



Release or Environment

All releases




Instructions

Passing the instance and table name in below link and accessing it from a browser returns the schema of the respective table in XML:


https://instance.service-now.com/table_name.do?SCHEMA


Examples 1: Returns DB Schema with list of all the tables

https://instance.service-now.com/?SCHEMA


Example 2: Returns schema for a specific table

https://instance.service-now.com/table_name.do?SCHEMA


NOTE: This is an OOB solution which refers to SchemaProcessor processor and returns the SCHEMA for a table or a list of all the tables.




Additional Information