SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Good naming convention
 Forum Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 08/25/2004 :  03:07:31  Show Profile
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.



Nah, doesn't look hard to read, crystal clear don't you think?

/rockmoose
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000