How to get the database name

HCL Leap Leap Forum
1

Hey there,

is there any possibility to get the sql database name of my leap app without having to search for it manually in the database. The names are very cryptic.

Best

Thomas

2

SELECT TABLENAME FROM FREEDOM.UIDS WHERE APP_ID = 'your app id';

This will give you the table in the APP_DATA schema for your app. If the app has more than 1 form or tables, then you will see more than 1 tablename. The UIDS table tells you which fields are associated with which table.