In which ossys table is the index information stored

In which (ossys) table is the index definition stored?

Hi Fred,


Good morning!


What's your object or trying to achieve?

Thank you and kind regards,


Chris

Hi Chris,

I like to generate merge statements using the columns from the unique indexes created on the entities.

I think there is no OSSYS table for the indexes, so i have to use the sys.index_columns table.

regards,

Fred.

Solution

Hi Fred,

if you have access to the database you can directly see the indexes there using and DB client tool.


Regards,

-PJ-


Solution

Hi Fred,

Some additional information. Here’s how indexes are being created on the Platform Database.

https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Data/Database_Reference/Database_Indexes

Regards,

Nordin