We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Where we can find list of tables in servicenow

ASWINI SAI PUTT
Kilo Contributor

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

 

1 ACCEPTED SOLUTION

cx2162
Tera Guru

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.

View solution in original post

4 REPLIES 4

cx2162
Tera Guru

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.

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

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

D_R
Tera Guru

Hello @ASWINI SAI PUTTA 

Please search in the navigator