Cary, you said "* Don't embed the object type in the object's name. I used to see this all the time with tablespaces called XYZ_TS, indexes called IND_THING, and so on."
what's your logic behind that? Rachel --- Cary Millsap <[EMAIL PROTECTED]> wrote: > Here's a start. Not a checklist by any means, just kind of a micro > pet > peeves list. > > * Decide today whether table names will be singular or plural. Do you > want a THING (singular) table? Or a THINGS (plural) table? > > * Don't use case-sensitive names. E.g., use THING (without quotes) in > your CREATE (DDL) statement, which can be spelled "THING", "thing", > "Thing", or even "tHiNG" in your developers' SQL. But don't make > developers type stuff like this... > > select "Name" from "Thing" where "Id" = y /* won't work without > "" > */ > > * Don't embed the object type in the object's name. I used to see > this > all the time with tablespaces called XYZ_TS, indexes called > IND_THING, > and so on. > > * Decide today whether you want to abbreviate or not. If you do, then > construct a formal, standard, consistent list of accepted > abbreviations. > Don't name one table CUSTOMER_THING and another CUST_HISTORY. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - NCOAUG Training Day, Aug 16 Chicago > - Miracle Database Forum, Sep 20-22 Middlefart Denmark > - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 > Dallas > > > > -----Original Message----- > Chambers > Sent: Tuesday, July 30, 2002 3:37 PM > To: Multiple recipients of list ORACLE-L > > All... > > Will some of you please provide some insight on your table naming > conventions? I'm in the very early planning stages of what will > likely > be a large and complex schema (IT asset inventory). I have a chance > to > start it correctly. TIA > > Gary Chambers > > //------------------------------------- > // Lucent Technologies GIO/Unix > // 4 Robbins Road, Westford, MA 01886 > // 978-399-0481 / 888-480-6924 (Pager) > // Nothing fancy and nothing Microsoft > //------------------------------------- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gary Chambers > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cary Millsap > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
