It always seems to me that using a naming convention on a table was redundant at best because every table is a table.
However, if you are doing a large project with a lot of tables, using a prefix can help you group similar tables together. For example, if you are building a complete accounting system it can be helpful to start all Accounts Receivable tables with "AR_" or Accounts Payable tables with "AP_", but it makes no sense whatsoever to prefix each table with "tbl" or worse, start each field with "fld". Paul H. Tarver Tarver Program Consultants, Inc. Email: [email protected] -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Tuesday, August 01, 2017 8:22 AM To: [email protected] Subject: [NF] back to naming conventions I just got a custom Access application that our product development team contracted out. Every table in the damn mdf file starts with tbl Just letting you know that fox doesn't own the <stupid> idea that type has to be baked into everything. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
