sqlsql-servert-sql

Database Naming Conventions by Microsoft?


I found Naming Guidelines from MSDN, but is it any guideline for MSSQL database from Microsoft?


Solution

  • The naming conventions used in SQL Server's AdventureWorks database demonstrate many best practices in terms of style.

    To summarize:

    You can find more details here:

    One caveat: database naming conventions can be very controversial and most database developers I've met have a personal stake in their style. I've heard heated arguments over whether a table should be named "OrderHeader" or "OrderHeaders."