RECOMMENDED NAMING STANDARDS - A Developer's Guide to Data Modeling for SQL Server - page 269

APPENDIX D

R ECOMMENDED N AMING
S TANDARDS

Object Type Prefix Example

Table tbl_ tbl_customer

View vw_ vw_open_orders

Stored Procedure prc_ prc_save_order_detail

User-Defined Functions udf_ udf_new_orderid

Triggers trg_ trg_new_order

Index idx_ idx_customer_name

Primary Keys pk_<table name> pk_tbl_address

Foreign Keys fk_<foreign key table> fk_tbl_address_tbl_customer

_<primary key table>

Default Constraint df_ df_customer_status

Check Constraints ck_ ck_customer_phone_number

Unique Constraints unq_ unq_customer_email

269