|
An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table. As you create aliases, Designer may prompt you to create other aliases. This occurs when the new aliases result in the need for additional aliases; in other words, creating such aliases entails the propagation of other aliases. In such a situation, two options are available to you:-
You can cause only the first table proposed to be aliased
-
You can alias all the tables listed (i.e. propagate the aliases)
-
Designer displays an alias in the Structure pane as a table. It links an aliased table to existing tables, re-arranging joins, as necessary.
|