在MSQLSMS中用蓝色和粉红色着色的单词的含义

Microsoft SQL Management Studio highlights some special words coloring them in blue or in pink. I would like to know which rule determines the color to use.

Microsoft SQL Management Studio突出显示了一些用蓝色或粉红色着色的特殊单词。我想知道哪个规则决定了要使用的颜色。

For example:

例如：

SELECT * FROM myTable

Both SELECT and FROM are special words are in blue.

SELECT和FROM都是特殊的单词是蓝色的。

UPDATE myTable SET myFlag = 'X

UPDATE is in pink while SET is in blue.

UPDATE为粉红色，而SET为蓝色。

2 个解决方案

#1

Google is, and will always be your friend! By default:

谷歌是，并将永远是你的朋友！默认：

https://docs.microsoft.com/en-us/sql/relational-databases/scripting/color-coding-in-query-editors

Extract:

提取：

Red -SQL string

红色-SQL字符串

Dark green -Comment

深绿色 - 卡通

Black on silver background -SQLCMD command

黑色银色背景-SQLCMD命令

Magenta -System function

洋红色 - 系统功能

Green -System table, view, or table-valued function. Also, the system schemas sys and INFORMATION_SCHEMA.

绿色 - 系统表，视图或表值函数。此外，系统模式sys和INFORMATION_SCHEMA。

Blue -Keyword

Teal -Line numbers or template parameter

Teal -Line数字或模板参数

Maroon -SQL Server stored procedure

Maroon -SQL Server存储过程

Dark gray -Operators

深灰色 - 操作员

#2

I would like to know which rule determines the color to use.

我想知道哪个规则决定了要使用的颜色。

Those colors are defined in SSMS..you can see all here and change them as well:Color Coding in Query Editor

这些颜色在SSMS中定义。您可以在此处查看所有颜色并更改它们：查询编辑器中的颜色编码

#1