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

Applies To	Convention	Example
Tables	[Noun], singular	Customer
Stored Procedures	[Verb][Noun]	UpdateCustomer
Views	[Noun]	CustomerOrders
Fields	[Noun]	Surname

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