New training course: Customizing SQL Prompt. Watch now.

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

  • 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.