SQL Prompt Keyword Case Handling

bngoal

I am looking at the SQL Prompt eval. There seems to be an option not to upcase SQL reserved words. When I set this to "Leave as is" it still upcases reserved words upon completion. Am I misinterpreting this option?

peter_peart

Hi there,

If you go to SQL Prompt Options > Inserted Candidates > Case and then select "Leave as is" for Reserved keywords, this will ensure that they are not automatically capitalised. The Reserved keyword option under the Layout tab relates purely to how the code is layed out after it has been written.

HTH,

Peter