Creating a CDT from a view -- why are the field names all lowercase?

Question

I have a view in the cloud database, and the column names are written in camelCase, with some genuinely containing capital letters. 
 I noticed that when creating a CDT, if you choose "create from table/view", then the generated fields corresponding to the columns are all in lowercase. Is there a reason that this is happening, and is there an easy way to prevent it?

ChristineH · Accepted Answer

Appian uses hibernate to connect and execute commands in the DB, using the set teneo property. When you are in the DB directly, creating tables/views follows the configuration set through a system variable. Initial settings will have Appian create objects as lowercase and the 'sql workbench' will create as you type it in. If you want these to be consistent, make adjustments in the DDL that you execute to create views. Hope that helps.

Creating a CDT from a view -- why are the field names all lowercase?

Top Replies