|
|
Basic names and DBEUserIDs are considered simple names. In some cases,
simple names are combined to form a compound identifier, which consists
of an owner name combined with one or more basic names, with periods (.)
between them.
Often you can abbreviate a compound identifier by omitting one of its parts.
If you do this, a default value is automatically used in place of the missing
part. For example, you can omit the owner name (and the period) when you refer
to tables you own; ALLBASE/SQL generates the owner name by using your logon
name.
A complete compound identifier, including all of its parts, is called a
fully qualified name. The following are compound identifiers:
Authorization group identifier —
[Owner.]GroupName
Column identifier —
[[Owner.]TableName.]ColumnName
Constraint identifier —
[Owner.]ConstraintName
Index identifier —
[Owner.]IndexName
Module identifier —
[Owner.]ModuleName
Procedure identifier —
[Owner.]ProcedureName
Rule identifier —
[Owner.]RuleName
Section identifier —
[Owner.]ModuleName(SectionNumber)
Table identifier —
[Owner.]TableName
View identifier —
[Owner.]ViewName
Different owners can have modules, tables, or views by the same name; the fully
qualified name of these objects must be unique in the DBEnvironment. Group
names, however, must be unique in the DBEnvironment.
|