Again, its all personal choice. I usually steer well clear of underscores as a rule as it can be hard to distinguish between multiple underscores..
Normally we go for the following approach: Tables : tblEventSettings And column names using Hungarian Notation (which has its adversaries too!): vcName cName iProductID dDateInserted etc.... the same for Store Procedures: [app]sp_[Get..Update..Delete][Feature] N -----Original Message----- From: Ian Sheridan [mailto:[EMAIL PROTECTED] Sent: 19 October 2004 14:57 To: CF-Talk Subject: Re: Field Naming Andrew, I usually go with this method: Name of application == "My Sample Application" == msa_ Table for users == msa_usr_users User table fields == usr_id usr_firstname usr_lastname And a Foreign Key would be like so == usr_uro_id (this would be a foreign key to the userroles table) This way when I do joins i do not have any confusion what table a column is from. Also I always use plurals in the table name because I do not have a tables that has only *one* item in it. Ian -- ---------------------- Ian Sheridan http://www.savagevines.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181832 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
