Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Same Column names in different tables?
It is standard practice to use the same name for a column in different
tables. Using your examples, one would use the 'implied' or optional
tablename with the column to qualify it when necessary such as:
CUSTOMER.CITY or CUSTOMER.ZIPCODE
Using names like CUSTOMER_CITY or CUSTOMER_ZIPCODE is not considered to be good practice.
Mike Rose
Other list members, your input(s) -- please ...
John Seitz wrote in message <36D205DF.C69E6D01_at_pobox.com>...
>Its been a couple of years since my Intro to Relational DB by Cobb, but
>I'm a little stumped.
>A person at work today told me that I should never have duplicate
>column/field names in different tables unless they are relationships.
>
>Am I on the pipe to think this person is crazy. There is only so many
>ways to have a column called CITY or ZIPCODE. Should I be putting the
>tablename in front of it like CUSTOMER_CITY?
>
>Any help would be appreciated. We will be fighting about this for days.
>
>John Seitz
>
>
Received on Mon Feb 22 1999 - 22:12:31 CST