Hallo,
I have a question regarding database schemas in Thinkwise.
Is it possible to use tables from a custom database schema (for example, a schema other than dbo) within a Thinkwise application?
If yes, are there any considerations or limitations when using a different schema?
What is the recommended approach when using tables from a schema other than dbo ?
Thank you
Jheng
Hi Jheng,
Using a schema other than dbo is not supported for the application model and its generated logic. The platform assumes that database objects are located in the default schema.
Technically, you can reference objects in another schema from the “Functionality” screen by using fully qualified object names. However, this is generally not recommended, as it falls outside the standard approach and can make your solution more difficult to maintain.
Could you share a bit more about why you want to use a different schema? Understanding your use case will help us suggest the most appropriate solution or determine whether there's a better alternative.
Kind regards,
Sjoerd Tiemens
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
