List Tables used by one eSpace - Query by eSpace Name

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'
Read More