Hello everyone!
I am looking for a standard naming convention for databases.
For example: is it good to use tablenames in column names like:
table = tb_id,tb_text,tb_name
and such.
Probably there is some kind of overall naming convention out there,
looked on google and such but only found
The example you give is a form of hungarian notation, wherein an
abbreviation representing the type of the variable is the first part
of the variable name. Hungarian notation is not generally considered
good practice for a variety of reasons; it is usually unnecessary, it
interferes with
Barry wrote:
Hello everyone!
I am looking for a standard naming convention for databases.
For example: is it good to use tablenames in column names like:
table = tb_id,tb_text,tb_name
I've for a long time been using an uppercase notation for databases.
Probably isn't the best system, but
FWIW a couple of weeks ago I read of a good reason not to use uppercase letters
in table column names. I can't remember what it was now, but it seemed like
sense at the time! My personal preference is to always use lowercase and
separate any words that need it with an underscore. Apart from
On Fri, 11 Aug 2006 17:00:35 +0100, James Harvard wrote
need it with an underscore. Apart from that I agree with Douglas
Sims that what is most readable is best.
select user_email, user_address, user_postcode from users where
user_id = %d;
# Hmm
select email, address, postcode from
On Aug 11, 2006, at 6:00 PM, James Harvard wrote:
FWIW a couple of weeks ago I read of a good reason not to use
uppercase letters in table column names. I can't remember what it was
now, but it seemed like sense at the time! My personal preference is
to always use lowercase and separate any
At 7:05 pm +0200 11/8/06, Paul McCullagh wrote:
Not so readable, I agree, but great when you want to find all references to a
particular database column in 1000s of lines of code!
Personally that's not something I've found myself wanting to do, but I can see
some people may need to do that.
I