Field present under "Show XML" but missing in dictionary

[Nisar3]

In a table record, I can see a column u_latitude when I click "Show XML"

But if I go to Configure->Table, then I do not see it listed there

Any idea why this could be happening?

[Nisar3 · Accepted solution]

Turns out it's an issue with deleted columns.

sys_storage_alias table will contain the field details. One will need to filter on element_name (column name) and table and delete it. If user is unable to delete it, he/she will need to raise a ticket with SNOW and they will do it via CHG.

[ShubhangiW]

I had a similar issue in case this helps - When I added a new field after the existing 125 fields, the column label showed empty while the column name showed fine in the Advanced view. This 126th field never showed in the normal view in ServiceNow studio. I was able to find the field in sys_documentation and added a column label and the field still continued to be invisible to GlideRecord.getElements() API. I also checked sys_dictionary and the field had no column label although the field showed. The field did not show in Table Schema Map of my staging table. In sys_storage_table, I only saw the staging table but no columns. 

I saw a forum question where they said the limit had been reached and they had to delete a (unused or less used) column to add a new one. I did that and that worked. I wish this limit did not exist on the number of columns we can add in a table or that it was more than 125.