what are the base tables in SNOW?

luman
Kilo Contributor

What are the base tables in servicenow? i know one table i.e Task table.Another one?

1 ACCEPTED SOLUTION

Chuck Tomasi
Tera Patron

Take a look here:



https://YOURINSTANCE.service-now.com/sys_db_object_list.do?sysparm_query=super_class%3DNULL



True base tables are those that can be extended so you may want to filter on the "Extensible" field where value is true.


View solution in original post

4 REPLIES 4

xiaix
Tera Guru

There are hundreds... what are you specifically looking for?



(on a side note, is it just me or every time I see "SNOW" in a topic header I immediately picture John) <shrugs>


find_real_file.png


Deepa Srivastav
Kilo Sage

Other is cmdb_ci...


To be specific cmdb_ci and task are called core tables...



Base tables are those tables which are extended, but itself is not an extended table.


Tables and Classes - ServiceNow Wiki




Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy.



Thanks,
Deepa


Chuck Tomasi
Tera Patron

Take a look here:



https://YOURINSTANCE.service-now.com/sys_db_object_list.do?sysparm_query=super_class%3DNULL



True base tables are those that can be extended so you may want to filter on the "Extensible" field where value is true.


JC Moller
Giga Sage

Hi,



If you just need to check the spelling of a table or some other minor task, then you could use this quick link:



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



Nashco Consulting has published an excellent SN data model pdf -document. Now in it's 34th revision.


You can download it here: http://www.nashcosolutions.com/professional-services/   Highly recommended!



- Jan