Finding all field names in a servicenow table

[Dennis Hancy]

BLUF: Where can we find a list of servicenow table names and column (field) names?

Specifically, I am looking at a Change Request.  The label on the screen for the column in question is "Planned end date".  I would like to know both the name of the table that houses the Change Requests data and the name of that column (field).

Elsewhere I have read that one can find table and column names by looking at the dictionary.  However I am unable to see that.  I suspect my user role is not set up for this feature.

Thanks  in advance for any light you can shed on this.

Dennis

[Saloni Suthar]

Hi Dennis,

You need an admin role to view the column name for the field. You can view the column by right-clicking on the field and Click Configure Dictionary. 

[Community Alums]

Hi @Dennis Hancy ,

There are two ways you can view all the tables and fields of that table 

1. Table - sys_db_object_list In this table you got all the table in a table view and by opening any record you got all the fields and all the value of the field like mandatory, display, type and many more

I selected Incident table here 

In related list you got ACL working on the incident table. 

2. Second way is more like graphical view Navigate through - All> System Defination > Tables & Column

For Example Here I select Incident table 

It shows all the field on incident table, and shows all the detail of that field

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak

[AndersBGS]

Hi @Dennis Hancy 

You can find table names here - write "sys_db_object.list" in the application navigator

To find a complete set of table names and their fields, write "sys_dictionary.list" in the application navigator. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Dennis Hancy]

Thanks @AndersBGS 

I tried "sys_dictionary.list", but it resulted in this message: "Security constraints prevent access to the requested page".  I suspect it's because I do not have an admin role?

However, when I try "sys_db_object.list", that results in a list of labels and other columns.  This was encouraging, so I searched for the label "Planned end date" - the column currently in question.  Unfortunately, that produced no results with the message "No records to display".  Could that also be due to not having an admin role?

If so, I might have to ask our internal admins for assistance on this.  But for the moment, my immediate need to is know how to reference this "Planned end date" field in the change request table in a query I am trying to create.

Thank again.

Dennis