General - Do you know object name should not be a reserved word?
Updated by Brady Stroud [SSW] 1 year ago. See history
123
SQL Server reserves certain keywords for its exclusive use.
- It is not legal to include the reserved keywords in a Transact-SQL statement in any location except that defined by SQL Server.
- No objects in the database should be given a name that matches a reserved keyword.
- If such a name exists, the object must always be referred to using delimited identifiers.
- Although this method does allow for objects whose names are reserved words, it is recommended that you do not name any database objects with a name that is the same as a reserved word.
- In addition, the SQL-92 standard implemented by Microsoft SQL Server defines a list of reserved keywords. Avoid using SQL-92 reserved keywords for object names and identifiers, ie. User, Count, Group, etc. They can be used if joined with other words.