Re: synonyms for table columns - are they possible?

Hello,
  Synonyms can also by used for: Data base links, packages and views but not schemas.

 A view is a stored query. The 'where' clause can be added to by the user without having to know the underlying data sources. It behaves like a table when used in other queries. If expressions are used to calculate a column result then column aliases must be used to name the expression.

Aliases are used in queries (or update statements) to give a name to a table, columns or column expressions to identify it within the query (or sub-query).

graham (aka grumpy)      

Allen Kirby <akirby_at_att.com> wrote...

|
| scheuric_at_wantnospam.com wrote:
| >
| > You can create synonyms. They are called aliases and are defined with
| > a create view command.
| >
| > -Sheilah Scheurich
| > DBA
|
| Actually synonyms, aliases and views are three different things.
| Synonyms are an alternate name for a table created with a create
| synonym command. A view is a view (look it up). And an alias is
| a way of identifying tables that appear twice in a select statement.
| --
| ---
| Allen Kirby AT&T ITS Production Services
| akirby_at_att.com Alpharetta, GA.

Graham Miller ...
Opinions expressed are mine, they are free, and worth exactly what they cost. Received on Mon Apr 28 1997 - 00:00:00 CEST