Red Gate forums :: View topic - No brackets with alias
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

No brackets with alias

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JT



Joined: 06 Aug 2009
Posts: 4

PostPosted: Mon Nov 12, 2012 3:35 pm    Post subject: No brackets with alias Reply with quote

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?
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Tue Nov 13, 2012 7:46 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
JT



Joined: 06 Aug 2009
Posts: 4

PostPosted: Tue Nov 13, 2012 9:14 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Tue Nov 13, 2012 10:15 pm    Post subject: Reply with quote

This would be considered a feature request.
You can direct feature requests to our uservoice forums.
http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions
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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group