Field present under "Show XML" but missing in dictionary

Nisar3
Giga Guru

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

 

Nisar3_0-1736323739790.png

 

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

 

Nisar3_1-1736324092076.png

 

Any idea why this could be happening?

1 ACCEPTED SOLUTION

Nisar3
Giga Guru

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.

View solution in original post

5 REPLIES 5

Nisar3
Giga Guru

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.