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.