Table name/reserved keyword

Question

0

Table name/reserved keyword

Dave Schuster posted 9 Years Ago

Just noticed that one of the table names in Rock (Group) is a reserved keyword word in SQL server. Just wondering if that is going to be a future update?

David Leigh · Accepted Answer · 2015-08-14T21:17-07:00

0

David Leigh replied 9 Years Ago

Dave,

It's unfortunate, but very unlikely that this will be renamed anytime soon as it would probably break a lot of existing SQL that is used to access the database directly.
As you may already be aware, you can get around this problem by enclosing the table name in brackets (ie. "SELECT * FROM [Group]")

Hope this helps!

David Stevens

9 years ago

Correct. There are quite a few reserved keywords in SQL so it's hard to avoid them all:
https://msdn.microsoft.com/en-us/library/ms189822.aspx

It's considered best practice for queries to surround all table names with brackets to avoid any conflict of interest.
Nick Airdo

9 years ago

Both David's are right :) and here are our SQL coding standards: https://github.com/SparkDevNetwork/Rock/wiki/Coding-standards#sql-coding-standards

Question

0

Table name/reserved keyword

0