Skip to Content (Press Enter)
UserImage.jpg
java domainq
5Views
3Comments
How to identify if a table is Multi-tenant or not by using PhysicalTableName 
Question
Database
Multitenant
Hi ,
I have a PhysicalTableName available . How Can I know whether the entity is multitenant or not.
This logic is part of the action.
Please advice.

Regards
jdq
0
0
13 Aug 2015
Copy Link
2012-03-02 13-17-21
Paulo Ramos
Staff
You can't from its physical table name. But the table will have a Tenant_Id column (and it's possibly in the metadata as well). Why do you need this?
0
0
14 Aug 2015
Copy Link
2019-11-12 17-31-26
Justin James
 
MVP
You could go to ossys_Entity, look up the record physical table name and then see if it is marked as multi-tenant...

J.Ja
0
0
14 Aug 2015
Copy Link
2020-05-29 14-07-58
Rajendra Singh
Hi Java Domainq, you can check the MULTITENANT attribute the the ossys_entity table like "Select MULTITENANT  from ossys_entity where PHYSICAL_TABLE_NAME=@physicaltablename" .


Thanks
Rajendra
0
0
04 Jun 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.