Formatting EXISTS after WHERE

2 Posts
2 Users
0 Reactions
381 Views
(@lamprey)
Member
Joined: 2 years ago
Posts: 8
Topic starter  

In my settings I have Linebreak set on "Select\After Where" checked. Which seems to work except when there is an EXISTS clause immediately following the WHERE. I expected the EXITS to be on a newline.

For example:

select
    foo
from
    dbo.tablename
where exists
    (
        select
            1
        from
            dbo.tablename2
    )

   
Quote
Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 234
 

Hi Lamprey,

the parser considers "WHERE EXISTS" and "WHERE NOT EXISTS" as a group of tokens which belong to the same keyword. Therefore there is no linebreak inserted inside a group of tokens which belong to the same keyword

Regards

Guido


   
ReplyQuote
Share: