How could I get information to know which tables used for each layer ?

[spiderman90]

I would like to get information from each layer .

Each feature class read different data from different tables at my database .

How could I get  information  to know which tables used for each layer in ArcMap ?

[spiderman90]

As your example , you have centerlines as table .

but in my case , the name here is not the same name of table at my database .

May be 5 tables are providing data for layer and other layer get the data from others tables .

in my case ,if I select on a cable as example then check the log file .

It shows me in the log file, that many functions used to show the data on cable .

select * from table a 

select * from table b 

……….

i mean , each layer getting the data from different tables at my database ,how could I see that tables name that joined to bring the data on layer ?

[RhettZufelt]

So, sounds like maybe you have a combination of layer with joins and/or views going on.

List by source will show you all layers AND tables that are currently loaded into your map document (image show View, Table, and Feature Class):

You can right click the layer in ArcMap, properties, source tab to show you the layer/table name/location:

If you have joins or relates, you can look in the Joins and Relates tab to see what tables are joined or related:

For views, you can find the data location in the source tab, then get properties in ArcCatalog, the definition will show the SQL that creates the view:

And if you have relationship classes set up in the database, you can get that info from the Relationships tab in the properties in ArcCatalog.

R_