THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

A system view to return a list of reserved words?

There was a discussion on our internal mailing list today about how to get a list of reserved words for SQL Server. It strikes me that there should be a system view that returns this. It could also return details of the version of the product where the word was added and an indication of if the use of the word is deprecated.

If you agree, you know the drill. Vote once, vote often :-)

Published Friday, March 25, 2011 11:08 AM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Scott Duncan said:

Aside from product version and deprecation, isn't this met by Books Online already?

Personally speaking, I'm not worried about when a keyword was made reserved (it's enough to know that it _is_ reserved) and whether or not it is deprecated is of not much use to me either (although possibly handy for development when choosing to name something).

March 29, 2011 5:36 PM

Greg Low said:

Hi Scott,

Not in a programmatic form. For example, if I want to build a trigger that makes decisions about names, etc. I want a programmatic version of this. The interest in knowing which version something was introduced in was more for those that need to build code to support multiple versions. Similar logic for deprecation.

What would probably also be interesting is to have some sort of grouping for the keywords that could be used for color coding in utilities, etc.

March 29, 2011 7:21 PM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement