by Chris123 » Wed 04 Apr 2012 09:33
by alexa » Wed 04 Apr 2012 11:12
We already have such a suggestion on our dbForge SQL Complete forum at UserVoice. We've just voted for it on your behalf: http://devart.uservoice.com/forums/8789 ... mn-name-en1) Is it possible to have an option to generate square brackets [ ] around columns names and possibly other objects such as tables?
Yes, SQL Complete generates an alias prefix for column names in the case it was defined.2) I understand that Express does not auto-generate aliases, but if I enter an upper case alias is it possible to get SQL Complete to honour this and generate column names with an upper case alias prefix?
by Chris123 » Wed 04 Apr 2012 14:06
SELECT * FROM CTL_A
SELECT * FROM CTL_Actions A
SELECT LastOccurredDate FROM CTL_Actions A
SELECT A.LastOccurredDate FROM CTL_Actions A
by alexa » Thu 05 Apr 2012 09:03
by Chris123 » Thu 05 Apr 2012 10:20
by alexa » Thu 05 Apr 2012 11:15
if there is a join across two aliased tables then I think it is a mistake not to add the alias to all the columns for the sake of clarity. Only doing it when columns share the same name across the tables does not seem right. Could I ask to add this as a feature request? A configuration option could be used to disable it for users who prefer the existing functionality.