RE: Checking the names of tables in a portal
hi
In Dynamics 365 portals, each portal has its own set of tables in the database, with a unique prefix for each portal's tables.
By default, the prefix for a portal's tables is the same as the portal's website name, with any special characters or spaces replaced by underscores. For example, if your portal website name is "My Portal", the prefix for your portal's tables will be "my_portal".
To verify which table belongs to which portal, you can look at the table name in the database. If the table name starts with the prefix for one of your portals, it belongs to that portal.
You can also use the "Portal Management" area in Dynamics 365 to view the database prefix for each portal. In the "Portal Details" section of the portal management page, you will see a field called "Database Object Prefix" which shows the prefix used for that portal's tables in the database.
If you have multiple portals and are unsure which tables belong to which portal, you can use a SQL query to search for tables with a specific prefix. For example, to find all tables with the prefix "my_portal", you can run the following query:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'my_portal%'
This will return a list of all tables with the specified prefix, which should correspond to the tables for your "My Portal" portal.
DAniele
