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

No brackets with alias

JTJT Posts: 5
edited November 13, 2012 4:15PM in SQL Prompt Previous Versions
I have an indexed view that I created a specific alias for which includes the WITH (NOEXPAND) option. My problem is that Prompt 5 is wrapping the entire alias (with the NOEXPAND option) in brackets. Is there a way to disable the automatic brackets?

Comments

  • Options
    There is an option to enclose identifiers within square brackets in
    SQL Prompt 5>Options>Inserted Code>Special Charachters
    Manfred Castro
    Product Support
    Red Gate Software
  • Options
    That option is unchecked for me so it is not causing my problem. Prompt 5 is checking to see if it is a reserved word (like SELECT) or has spaces and is automatically putting the brackets around the alias. However, in my case, I don't want this behavior.
  • Options
    This would be considered a feature request.
    You can direct feature requests to our uservoice forums.
    http://redgate.uservoice.com/forums/944 ... uggestions
    These forums are actively monitored by our development team and allow our users to reuest features and vote on them.
    If a feature recieves a significant amount of votes or is deeemed to have merit development may include the feature in a future release.
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.