I am finding that SQL Prompt 4 does not correctly do Format SQL on create/alter view statements. It may be that this primarily happens if there is a comment in the view text. I frequently place comments directly after the AS keyword as a convention.
No... nothing to do with comments. It appears that running Format SQL on an alter view merely strips out any leading whitespace from all view body lines, and that's it. Comment out the "alter view <view> as" phrase and Format SQL correctly formats the resulting select statement as normal.
No... nothing to do with comments. It appears that running Format SQL on an alter view merely strips out any leading whitespace from all view body lines, and that's it. Comment out the "alter view <view> as" phrase and Format SQL correctly formats the resulting select statement as normal.