SQL adaptation guide For SQL SERVER 2005, 2008, 2012 / Data manipulation |
Microsoft™ Transact-SQL does not allow you to use reserved words as database object names (tables, columns, constraint, indexes, triggers, stored procedures, ...). An example of a common word which is part of SQL SERVER grammar is 'go' (see the 'Reserved keywords' section in the SQL SERVER Documentation).
Database objects having a name which is a Transact-SQL reserved word must be renamed.
All BDL application sources must be verified. To check if a given keyword is used in a source, you can use UNIX™ 'grep' or 'awk' tools. Most modifications can be automatically done with UNIX tools like 'sed' or 'awk'.
You can use SET QUOTED_IDENTIFIER ON with double-quotes to enforce the use of keywords in the database objects naming, but it is not recommended.