Competition: What’s your favorite Redgate tool? Enter now.
Format SQL has started adding AS prior table object aliases
Previously, SQL Prompt preserved the the omission of `AS` on object aliases, however, as of this morning it has started adding it. As a simple example If I had the SQL below:
SELECT MT.MyColumn AS Col<br>FROM MyTable MT<br>It would change it to
SELECT MT.MyColumn AS Col<br>FROM MyTable AS MT;
Previously it would have simply added the semicolon, as I prefer to not use AS when aliasing an object (although i do for columns).
I haven't performed an update to Prompt this morning, and I'm running the latest version, so not sure why the behaviour has suddenly changed. I had a look at the style options, and there's nothing to enable (or disable) he use of AS for object aliasing.
Any ideas why this has changed and how to revert the behaviour?
0 · Share on Twitter