No brackets with alias

JT

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?

Manfred.Castro

There is an option to enclose identifiers within square brackets in
SQL Prompt 5>Options>Inserted Code>Special Charachters

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.

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.