List Application Entities (Outsystems Metamodel)

SELECT 
    App.[NAME] AS [Application_Name],
    Esp.[NAME] AS [Module_Name],
    Ent.[NAME] AS [Entity_Name],
    Ent.[PHYSICAL_TABLE_NAME] AS [SQL_Server_Table_Name],
    Ent.[Data_Kind] AS [Data_Kind],
    Ent.[IS_SYSTEM] AS [Is_System],
    Ent.[IS_ACTIVE] AS [Is_Active]
FROM 
    [dbo].[OSSYS_APPLICATION] App
INNER JOIN 
    [dbo].[OSSYS_APP_DEFINITION_MODULE] AppMod ON App.[ID] = AppMod.[APPLICATION_ID]
INNER JOIN 
    [dbo].[OSSYS_MODULE] Mod ON AppMod.[MODULE_ID] = Mod.[ID]
INNER JOIN 
    [dbo].[OSSYS_ESPACE] Esp ON Mod.[ESPACE_ID] = Esp.[ID]
INNER JOIN 
    [dbo].[OSSYS_ENTITY] Ent ON Esp.[ID] = Ent.[ESPACE_ID]
WHERE 
    App.[ID] IN (/* INSERT_TARGET_APP_IDS_HERE */) -- Provide your targeted App IDs here
    AND App.[IS_ACTIVE] = 1   -- Only active applications
    AND Esp.[IS_ACTIVE] = 1   -- Only active modules/eSpaces
    AND Ent.[IS_ACTIVE] = 1   -- Only active entities (ignores deleted attributes/entities)
ORDER BY 
    App.[NAME] ASC, 
    Esp.[NAME] ASC, 
    Ent.[NAME] ASC;