Can I change the column names for the database views?

[MMKK]

Hi All,

I have 2 questions:

1. How do I get variable information in the Database view.

2. how to change the column names in database view. It is very confusing to have Number as a column name for both task and requested item number.

Kindly help.

[rahulpandey]

Hi,

You below is the way, you can see variables in database view

https://community.servicenow.com/community?id=community_blog&sys_id=e94d2229dbd0dbc01dcaf3231f96190f

For changing the Label follow this

https://community.servicenow.com/community?id=community_question&sys_id=baaf7e2ddb58dbc01dcaf3231f961959

[Raju Koyagura]

Technically you should create Field Label something like below and in the element name use table prefix. 

EX: I tried to change the number with "New Name" and the prefix of the incident table in the view given as inc. So the element name should be inc_number

[DorianK]

I know this is old, but thought I would add a couple things here:

I really wish ServiceNow would add that to the docs to include the table prefix (which can be found on the database view) https://docs.servicenow.com/bundle/quebec-platform-administration/page/use/reporting/task/t_RelabelAColumn.html