question Re: Where we can find list of tables in servicenow in Developer forum

Where we can find list of tables in servicenow

ASWINI SAI PUTT — Mon, 30 May 2022 15:47:31 GMT

Where we can find the list of tables present in servicenow instance.

Re: Where we can find list of tables in servicenow

cx2162 — Mon, 30 May 2022 15:49:08 GMT

Type "Tables" and open the module "Tables" under system definition application menu.

Or simply type sys_db_object.LIST and press enter. This will open the list of all tables present in the instance in a separate tab.

Re: Where we can find list of tables in servicenow

D_R — Mon, 30 May 2022 15:57:27 GMT

Hello @ASWINI SAI PUTTA

Please search in the navigator

Re: Where we can find list of tables in servicenow

Dennis Hancy — Thu, 30 Nov 2023 13:23:33 GMT

Good morning.

I have a follow-up question.

I navigate to Reports -> Create New. From there, I select Table as the Source Type. In the drop down below that, I select the table that I want.

When I type "sys_db_object.LIST", it does indeed present me with a list of all tables (5000+ tables); however, the table I see in Reports -> Create New, as I noted above, is not present in this list.

Can you think of a reason I cannot see my table in this case?

Thank you.

Dennis

Re: Where we can find list of tables in servicenow

cjpolanco — Fri, 23 Aug 2024 17:16:15 GMT

It might be an acl issue? where there is a restriction on certain tables to not be reportable or a missing role?