Re: column prefixes

In your example I would say the purpose of the prefixes is to identify which table the column name refers to. In my opinion I would prefer to use table aliases to differentiate between columns with the same name in different tables. e.g. using your example, note I would also change the '=' to a 'LIKE' in the condition.

SELECT distinct em.employee_code
FROM employee em,

        department de
WHERE em.dept_code = de.dept_code
AND de.dept_name LIKE 'SOC%';

I have seen prefixes used in tablenames to identify the application that the tablename belongs to. This may be fallout from tablenames automatically generated by CASE*Dictionary which had the habit of prefixing tablename when generating from the logical data model.

suhasu_at_hotmail.com wrote:

>Hi,
>
>Are there any pros/cons to having table identifying
>prefixes to column names???
>

SNIP Received on Mon Feb 23 1998 - 00:00:00 CET