naming conventions for constraints

Hello,

after studying some documents on naming conventions the main recommendations for constraints seem to be that constraints should be named as the table it is applied to, followed by a suffix which identifies its type.

table name: systems

possible constraint names could be:

systems_pk    --> primary key constraint
systems_fk     --> first foreign key constraint
systems_fk2    --> second foreign key constraint

A second approach could be to apply the column name as well:

systems_id_pk --> primary key constraint systems_hostname_fk --> foreign key constraint

What are your opinions?

Sönke Received on Wed Apr 30 2003 - 07:00:41 CDT