Edit Format Style for datatypes in SQL Prompt

epennekan

I have set a custom format style already.

Thus, when I select all my code and click "Format SQL" it does clean it up nicely; however, I want it to remove the brackets around my data types.

Example what I have: [VARCHAR](50)

What I want it to look like is: VARCHAR(50) -- Note no [   ] 

Is this possible?

Mac_F

Hi Etienne,

Yes. There is a way to remove the brackets from all data types. It is Options -> Format -> Styles -> Actions -> Add/remove square brackets = YES, Remove unnecessary brackets = YES
However this will also remove any other brackets a long with it.

Unfortunately, we do not currently have an option for just removing the brackets around data types. This would be considered a feature request to add in a later release of SQL Prompt.

You can post a new feature request on our UserVoice forum here:

https://redgate.uservoice.com/forums/94413-sql-prompt

Our product manager uses that as an important resource when deciding new features.

Best regards,