Andy Davies <> wrote: >> So where do you fall in creating your names? > > I am agnostic about including v/ vu/ view in view names (actually I > sometimes use c_tablename, especially when I only had to create the > view because no-one here knows how to make Business Objects respect > aliases/ dbLinks), I [try to remember to] use plurals for tables and > singulars for columns. I don't like including an 'app_' prefix - I > use database name (or the strangely ambiguous 'user' in Oracle/ SQL > Server). I *definitely don't like the convention in one of our > bought-in systems where all column names are 'Tn_Rowname' where 'Tn' > was at some previous time the table name. The use of case is v. iffy > in Oracle/ SQL Server (but I'm guilty, especially when it upsets the > BO lot <g>).
I'm more into the Tablename is just a table name and has no need of identifier because the fullTableName describes what it is. So ORD_Master would be OrderHeaders Now my SPs will use the namespace they their called from +_+SpName I use the _ to visually separate and sort by. In column names I NEVER reference the data type of the column. All Keys are ??????ID and their data type is bigint. Unless GUID was chosen before I got there :( All fKeys are the same name as the primary table's column. Dates are all smalldatetime unless seconds count. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.15/579 - Release Date: 12/7/2006 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
