Re: How to create aliases for tables

Mirwais Qader wrote:
>
> I would like to create a set of aliases for tables so that
> our users do not have to remember some vague names.
>
> Example: I want our "sc_customer" to be "clients"
>
> Can this be done? I know in SQL we can do
>
> select C.Number
> from sc_customer C
> where .....
>
> What I am interested in is a set of "global aliases".
>
> Please respond with email!
> Thank You!
> -Mir.

What you want are synonyms. The synonyms can be made public or private and permission can be granted on the synonym. e.g. create public synonym clients for <schema>.sc_customer;

Check the manuals for synonyms for exact syntax and usage rules.

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.