How can we help you today? How can we help you today?

No brackets with alias

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?
JT
0

Comments

3 comments

Sort by
  • Manfred.Castro
    There is an option to enclose identifiers within square brackets in
    SQL Prompt 5>Options>Inserted Code>Special Charachters
    Manfred.Castro
    0
  • JT
    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.
    JT
    0
  • Manfred.Castro
    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
    0

Add comment

Please sign in to leave a comment.