Where come attribute column in each feature class (Attribute names ?tables name ?

440
4
05-17-2023 10:58 PM
spiderman90
Occasional Contributor

Hello , 

Feature class has data from different tables .
as examples 

Feature class contain :id ,year of construction ,type ,….

But type get from table A

,year of construction from table b

i would like to find ,which each attribute names  come from which table .

it is important to me ,which attribute names came from which table  for each feature class .


how could I do that ? 
thanks in advance 

0 Kudos
4 Replies
BarryNorthey
Occasional Contributor III

Assuming you are doing a temporary join such as Add Join, open a Fields View of the resulting attribute table. In my example, srmadata is the name of the join table. The top two rows are from the input table.

BarryNorthey_0-1684421268968.png

 

 

0 Kudos
AlyciaRajendran_esri
Esri Contributor

Hi @spiderman90!

There are a few ways to do this.

1. Use Fields view, as suggested by @BarryNorthey  You can get there by right-clicking on the layer > Data Design > Fields:

AlyciaRajendran_esri_0-1684424013267.png

Or, from the table menu:

AlyciaRajendran_esri_1-1684424048817.png

 

2. You can also change the display of field names from alias to fully qualified field names from the table. You get there from the table menu as well, it is a checkbox:

AlyciaRajendran_esri_2-1684424090132.png

I hope this helps!

- Alycia

0 Kudos
spiderman90
Occasional Contributor

Thanks but how could I do that at oracle database sql developer?

0 Kudos
AlyciaRajendran_esri
Esri Contributor

I unfortunately cannot help with that, as I work with ArcGIS Pro. Oracle has their own forums, perhaps someone there can assist: Developer Community - Oracle Forums

0 Kudos