Database Conventions

Following a set of database conventions improves the readability and understanding of the database and related sql. Every DBA has their own thoughts about which convention to follow. This is ours

Naming

• Names must clearly describe the object
• Use PascalCase for all names
• Don’t use Hungarian notation (like intNumber)
• Don’t use abbreviations except if they are well-known

SQL Queries

• Use consistent indentation
• Use UPPERCASE for keywords, like SELECT, FROM, WHERE, and JOIN
• Use meaningful aliases, not single letters or abbreviations
• Use single quotes ('string') for string literals and double quotes (“identifier”) for identifier

Links

Poor SQL - Instant Free and Open-Source T-SQL Formatting