Which Entity points which SQL Tables in the BackEnd

DAVID CHEN

Question

Seems like its in one of OSURS_XXX_EntityName

Is there a way to find out exactly which Entity in OS belongs to which SQL Table, so I can do some select queries in the back end

24 Aug 2016

Fabian

Something like the SQL below will help you find the table name by entity name. Run it in the outSystems database.

SELECT [PHYSICAL_TABLE_NAME]
,[NAME]
FROM [OutSystems].[dbo].[ossys_Entity]
where name = 'your entity name'
and ESPACE_ID = your espace id

you can find the ESPACE_ID in [OutSystems].[dbo].[ossys_Espace]

25 Aug 2016

Rajendra Singh

Yes Fabian is right you can get the physical table name from ossys_entity.

Thanks

Rajendra Singh

25 Aug 2016

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.