What are the challenges you face when working across database platforms? Take the survey

Keyword list - where is it?

mgmg Posts: 6
edited February 27, 2007 11:22AM in SQL Prompt Previous Versions
The original product (PromptSQL) had a utility for adding keywords. Is there or will there be one in this product?


  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi there mg,

    The current version bases the list of keywords it uses on the version of SQL Server you connect to, so SQL Server 2005 has a much more extensive list than SQL Server 7 or 2000. I'm assuming your enquiry relates to wanting to tweak the auto-capitalisation/auto-lowercasing functionality? We may make this more configurable in the future but for now you can't edit the keyword/data type/function lists.

    If you want to configure the list of words after which the popup will appear you can do this by editing the EngineOptions.xml directly. You'll find this in C:\Documents and settings\{username}\Local Settings\Application Data\Red Gate\SQL Prompt 3. The list of words is at the end of the file in the <PopupTriggerWords> section.

    Hope that helps.

    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    Thank you for your "prompt" reply
    yes - auto/upper functionality is what I would like to tweak. It would be nice to match the color coding with the uppercase. Definitely not a show stopper, though.
Sign In or Register to comment.