The CreatorCon Call for Content is officially open! Get started here.

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

Chandra Sekhar6
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

Chandra Sekhar6
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
Giga Guru

Hello @ASWINI SAI PUTTA 

Please search in the navigator