If i use SQL Server key name( like where , select, value ) as one of the column name in my user defined table, is there any performance impact ?

Question

Hi Experts, In one of my table, i had column name "Value". but when i write any T-SQL statement by using that column, it is appeared as blue color since it is system defined keyword. so is there is any performance issue or other issues if I use SQL server key words as column names. Please provide me insights for this. Thanks in advance.

Answer 1

When you want to use sql server keywords as column names, you can use [],
for example:

     [values]  

in the form of [], it has no effect on performance.But it is not recommended to use sql server keywords as column names.

Regards
Echo

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

"Value" is a Reserved Keywords (Transact-SQL), you should avoid using them for user object names.
Blue is the syntax high lightning of SSMS and has no further effect; see Color Coding in Query Editors