> 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>).
Andrew Davies MBCS CITP - AndyD 8-)# ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** _______________________________________________ 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.
