HP 3000 Manuals

ALLBASE/SQL Reference Manual

Compound Identifiers 

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.

MPE/iX 5.5 Documentation