SQL DB General Rules

SQL DB General Rules

  • Do not use spaces in the name of database objects.
  •  Do not use SQL keywords as the name of database objects. 
  • In cases where this is necessary, surround the object name with brackets, such as [Year]. 
  • Do not prefix stored procedures with ‘sp_’2. 
  • Prefix table names with the owner name3.