List Tables used by one eSpace - Query by eSpace Name

15/04/2010

select ENESPACE.NAME, ENENTITY.NAME, ENENTITY.PHYSICAL_TABLE_NAME
from dbo.ossys_Espace ENESPACE inner join dbo.ossys_Entity ENENTITY
    on ENENTITY.ESPACE_ID = ENESPACE.ID
WHERE ENESPACE.NAME = 'espacenameHERE'