How to identify if a table is Multi-tenant or not by using PhysicalTableName 

How to identify if a table is Multi-tenant or not by using PhysicalTableName 

  
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

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?
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
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