how to change Default Code Colors in sql SSMS 2016?

Question

Post reply

how to change Default Code Colors in sql SSMS 2016?

Tac11

SSCertifiable

Points: 6976
More actions
June 19, 2018 at 1:08 pm

#413908

Hi Gurus,
I downloaded SQLSSMS 2016, everything looks fine except light green color font for "System table, view, or table-valued function. Also, the system schemas sys and INFORMATION_SCHEMA". To be more specific when I type 'sys.databases' the color of the font light green is very disturbing for my eyes.
I went to below site to change it but didn't help!! Can someone please post here step by step instruction?
https://docs.microsoft.com/en-us/sql/relational-databases/scripting/color-coding-in-query-editors?view=sql-server-2017

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99126 More actions · Answer 1

"disturbing" is an odd choice of word. 🙂

Have you considered using the Dark Theme?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Tac11 SSCertifiable Points: 6976 More actions · Answer 2

First of all thanks for your reply. Secondly, sorry, English my second language. Is 'bothering' sounds better? (Don't get me wrong, I like when people point my 'weakness' because that helps me to do more research and so I can come up with better one 🙂
Anyway I also tried dark, but I didn't like it. I like previous versions of SQL SSMS

Sue_H SSC Guru Points: 90860 More actions · Answer 3

Tac11 - Tuesday, June 19, 2018 1:08 PM
Hi Gurus,
I downloaded SQLSSMS 2016, everything looks fine except light green color font for "System table, view, or table-valued function. Also, the system schemas sys and INFORMATION_SCHEMA". To be more specific when I type 'sys.databases' the color of the font light green is very disturbing for my eyes.
I went to below site to change it but didn't help!! Can someone please post here step by step instruction?
https://docs.microsoft.com/en-us/sql/relational-databases/scripting/color-coding-in-query-editors?view=sql-server-2017

Go to Tools -> Options -> Environment ->Fonts and Colors

The top drop down labeled Show settings for, select: Text Editor
In the Display Items list towards the bottom select: SQL System Tables

Then change the item foreground color.

Sue

Tac11 SSCertifiable Points: 6976 More actions · Answer 4

It worked!!! Hat's off to you Sue. Thanks you so much for your kind reply.

Sue_H SSC Guru Points: 90860 More actions · Answer 5

Tac11 - Tuesday, June 19, 2018 1:52 PM
It worked!!! Hat's off to you Sue. Thanks you so much for your kind reply.

Glad that worked for you - thanks for posting back!

Sue