quote:

---

originally posted by Kristen
The name of my Foreign key would be FK_ACC_AR_INV_ACC_AR_CUST_ID - which is made up of the "nicknames" for the "Parent" table, the "Child" table, and the descriptive part of the child table's column name - where the FK is a multi-part key I use the first column name, and on the odd occassions where that is not unique I use a tie break.

The FK name looks hard to read, but given that we are dealing with the System/Subsystem/TableNickName names all the time it breaks into its parts, and we are obviously used to it.

---