I hate that naming convention. In fact, in many cases, you want your
developers to be unaware if they're querying a table or view -
particularly when it's select only access. Why should they know if
you're giving them just the part of the data that they need? All they
should need to know is that the data that they need is in object X.

----- Original Message -----
From: Marlon Moyer <[EMAIL PROTECTED]>
Date: Thu, 24 Jun 2004 10:37:40 -0500
Subject: database naming conventions
To: CF-Community <[EMAIL PROTECTED]>

I just got told that I have to go back and put a vw prefix on all my
views and tbl prefix on my tables so that people know when they're a
table or a view when writing queries.  Jeez, that just seems a little
silly to me.  If you don't know if you're writing against a table or a
view should you be writing queries anyway? :)

Anyone else have to follow silly rules like this?

Marlon________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to