There's the sqlmap eSpace that you could use, don't know if it is downloadable somewhere. Also, you can use this query:

select * from ossys_Entity where name = @logicaltablename

to find a table's physical name (although of course there may be more than one result, as each eSpace could define the same logical table name).

I think the biggest problem with this request is that Service Studio may not be aware of the physical table names at all, since the compiler produces them.

This can be achieved by querying the metadata API/entities. Physical_Table_Name attribute on the Entity entity provies you that value.

Goncalo, what's this metadata API you mentioned?

Go to Add/Remove references and under the (System) producer you can find a lot of the metamodel of the platform.
These entities can be referenced just as any other and queries can be performed on them.

This way you are able to know most of the underlying information for what is produced by the platform.



Cheers

Thanks, this is quite useful.