开发者

Is there a way to query the list of reserved keywords in SQL Server 2008?

开发者 https://www.devze.com 2023-02-12 12:23 出处:网络
I am writing a 开发者_开发问答program that generates standard alias names per table name. In order to do so I need to make sure I do not generate an alias name that matches a sql reserved keyword (ex:

I am writing a 开发者_开发问答program that generates standard alias names per table name. In order to do so I need to make sure I do not generate an alias name that matches a sql reserved keyword (ex: 'max', 'top', 'abs' etc). I realize that I could put the generated alias name into square brackets to use a literal name regardless of reserved keywords... but I would to avoid doing so. Is there a table that can be queried that contains a list of the reserved keywords?


Make your own table out of this list:

http://msdn.microsoft.com/en-us/library/ms189822.aspx

0

精彩评论

暂无评论...
验证码 换一张
取 消