Formatting of parentheses in WHERE and JOINs

[tomashiba]

Is it possible to set formatting of parentheses on WHERE and JOINs?
Let's say I have a select statement and I want it to be formatted like this:

Code: Select all

USE [TSQLV3];
GO

SELECT 
	* 
FROM [Sales].[Orders] AS [O]
INNER JOIN [Sales].[Customers] AS [C] 
ON 
(

	[C].[custid] = [O].[custid]

)
WHERE 
(
	EXISTS
	(
		SELECT 
 			* 
		FROM [Sales].[OrderDetails] AS [OD]
		WHERE 
		(
    
			[OD].[orderid] = [O].[orderid]

			AND
			[OD].[qty] > 40
    
		)
	)
);

The "Format Document" command with re-format it to:

Code: Select all

USE [TSQLV3];
GO

SELECT
	*
FROM [Sales].[Orders] AS [O]
INNER JOIN [Sales].[Customers] AS [C]
ON
	(

	[C].[custid] = [O].[custid]

	)
WHERE
	(
	EXISTS
	(
		SELECT
			*
		FROM [Sales].[OrderDetails] AS [OD]
		WHERE
			(

			[OD].[orderid] = [O].[orderid]

			AND
			[OD].[qty] > 40

			)
	)
	);

Is there a section in "Options/Text Editor/Formatting/Profiles" to set rules for parentheses in general or for JOINs and WHERE clauses?

TIA

Tom

[alexa]

We will investigate this issue and will answer you as soon as possible.

[alexa]

Sorry for the delay on this.

There is no such a possibility in dbForge. Though, we have added a suggestion on our UserVoice forum where other users can vote for it https://devart.uservoice.com/forums/878 ... osed-in-br

You can also vote for this feature.

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.