Object naming standards

Do you have a standard naming convention?

Most application databases have standard prefixes for tables (tbl_), views (vw_), user stored prcedures (usp_), user defined functions (udf_) etc.

But do you have a standard for Primary Keys, Foreign Keys, constraints and defaults?

By creating a standard you can make debugging and tracing of violations back to the source a lot quicker. An example would be PK_schemaname_tablename for primary keys. FK_foreigntableschemaname_foreigntablename_foreigntablecolumnname.

Defaults are defined as DEF_schemaname_tablename_columnname.

Check constraints use CHK_ instead of DEF_ and unqiue constraints are UQ_ instead of DEF_.

It is a lot easier to find the issue with UQ_Patient_Picture_FileStreamID rather than a system generated UQ__Picture__2957490CF9A66DF5, although there can be an issue with the name becoming too long and unwieldly.

Just have a standard that works for you.