What are the challenges you face when working across database platforms? Take the survey
Options

Possible to left align the AND predicate?

Pixelated_1Pixelated_1 Posts: 6 Bronze 1
edited September 18, 2015 6:28AM in SQL Prompt
Is there a way edit the automatic formatting of the AND predicate to left align under the WHERE i.e
SELECT	TOP (50) 
		o.name
FROM	master.sys.objects o
WHERE	o.object_id = 3
AND		o.name LIKE '%sys'
and not
SELECT TOP ( 50 )
		o.name
FROM	master.sys.objects o
WHERE	o.object_id = 3
		AND o.name LIKE '%sys'
?

Comments

  • Options
    Hi Pixelated_1,

    With the current system, unfortunately this isn't possible.

    We're currently working on improving the formatting system and this is something that it will support. If you find any more areas with the current formatting system where we can improve, please put them into the formatting survey here.

    Best regards,

    David
Sign In or Register to comment.