Can we change the database view column label which is already in place

[Gayathri5]

Hi experts,

Desparately need to know how to change the column label of database view, i have 2 columns with ID ...so wanna change it...attaching the screenshot .

I tried going through links but i couldn't ...tell me the steps

[Jerick I]

Hi @Gayathri5,

This doesn't seem feasible to me because what the database view is doing is joining the two tables and presenting the columns within them. The only thing you can change in this area is the field's name but that will be a permanent change.

[Gayathri5]

So if its picking label from actual table and we can't change them in database view instead change the label in table which will be permanent change in all the places?

[Jerick I]

Hi @Gayathri5,

Yes, that is correct.

[newhand]

@Gayathri5 

I have found the solution，please read the Product documentation bellow。

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/use/reporting/task/t_RelabelAC...

Relabel a column

Tokyo

Sometimes, two different tables may have fields of the same name that are both important (such as two tables with a sys_updated_on field). For clarity, relabel one of the fields.

Before you begin

Role required: admin.

About this task

To create clear reports, relabel the fields on the Database View [sys_db_view] table without changing the names of the fields.

Procedure

1. Navigate to All > System Definition > Language File.
2. Select New.
3. Fill in the form as follows:
   New language file fieldsName Description

   Table	Name of the database view
   Label	Display label
   Plural	Plural form of the display label
   Element	Name of the field on the database view

4. Select Submit.