Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

Appendix A. Naming Conventions

by Orryn Sledge

Recommended naming conventions for SQL Server are listed in Table A.1.

Table A.1. Suggested Naming Conventions

Object	Naming Convention	Example
database	(business name)	sales
table	(business name)	customer
constraint
foreign key constraint	(table name) + _fk	customer_fk
primary key constraint	(table name) + _pk	customer_pk
unique key constraint	(table name) + _uniq	customer_uniq
Or
foreign key constraint	fk_ + (table name)	fk_customer
primary key constraint	pk_ + (table name)	pk_customer
unique key constraint	uniq_ + (table name)	uniq_customer
index
clustered	(column_name) + _cdx	customer_id_cdx
nonclustered	(column name) + _idx	customer_id_idx
trigger
delete	(table name) + _dtr	customer_dtr ...